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!

Disabling default constraint in a table is possible?

Lokesh ANov 17 2020

create table orders
(
order_id varchar2(10) primary key,
prod_id varchar2(10),
order_date date,
QTY integer default 1
);

In orders table i want to disable the default constraint value, but i am not able to drop the constraint as well. Right now I used alter statement. like this ALTER TABLE orders MODIFY qty DEFAULT NULL;
Is any possibility to drop or disable the default constraint in oracle?

Comments
Post Details
Added on Nov 17 2020
2 comments
1,120 views