In Oracle, sometimes you may need to DISABLE PRIMARY KEY
constraint, you use the following DISABLE PRIMARY KEY
statement to disable primary key.
DISABLE PRIMARY KEY
in "tblCustomer" table:
Note:
In the above example, we are disabling primary key in "tblCustomer" table using DISABLE PRIMARY KEY
constraint.