Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle ENABLE PRIMARY KEY Constraint

In Oracle, sometimes you may need to ENABLE PRIMARY KEY constraint if you disabled, you use the following ENABLE PRIMARY KEY statement.

Oracle ENABLE PRIMARY KEY Constraint example

The following Oracle, enable primary key using ENABLE PRIMARY KEY in "tblCustomer" table:

Example

ALTER TABLE tblCustomer
ENABLE PRIMARY KEY;

OR

ALTER TABLE tblCustomer
ENABLE CONSTRAINT pk_customrer;

Note:

In the above example, we are enabling primary key in "tblCustomer" table using ENABLE PRIMARY KEY constraint.