Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change NOT NULL DEFERRABLE to NULL

JackKApr 27 2021 — edited Apr 27 2021

Hi.
Suppose I have a column with constraint NOT NULL INITIALLY DEFERRED DEFERRABLE.
Why do I receive ORA-01451 when executing:
alter table myTab modify myColumn varchar2(40) NULL;
Regards,
Jacek

Comments
Post Details
Added on Apr 27 2021
3 comments
623 views