Explain how to DISABLE and ENABLE constraint

Explain how to DISABLE and ENABLE constraint.

Constraints in Oracle like Foreign keys, CHECK constraint are used to maintain data integrity. Oracle by default enables a constraint if not enabled or disabled explicitly.

Enabling a constraint :
ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

Disabling a constraint :
ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

Explain how to DISABLE and ENABLE constraint.

Disable a constraint by using the DISABLE clause.
Enable a constraint by using the ENABLE clause.
Statement Auditing, Privilege Auditing and Object Auditing in oracle
Define Statement Auditing, Privilege Auditing and Object Auditing in oracle - Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.....
How to retrieve 5th highest sal from emp table? - oracle
Retrieve 5th highest sal from emp table - SELECT DISTINCT (emp1.sal) FROM EMP emp1 WHERE &N = (SELECT COUNT (DISTINCT (emp2.sal))...
What is $FLEX$ and $PROFILES$? Where are they used? - oracle
What is $FLEX$ and $PROFILES$? - $FLEX$ is used to get a value used in the previous value set. It is usually used to retrieve the Flex value contained in an AOL value...
Post your comment

Related Content

Follow us

▲