Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

CheckConstraintsPLSQL

DROPPING, DISABLING and ENABLING CHECK CONSTRAINT in Oracle SQL – PLSQL

by

In Oracle SQL / PLSQL a CHECK CONSTRAINT allows us to specify a condition on each record / row of a table. Important points about CHECK CONSTRAINT in Oracle SQL / PLSQL: In Oracle SQL / PLSQL a CHECK CONSTRAINT can never be defined on a VIEW but only on a table. A CHECK CONSTRAINT […]

CHECK CONSTRAINT in Oracle SQL – PLSQL

by

In Oracle SQL / PLSQL a CHECK CONSTRAINT allows us to specify a condition on each record / row of a table. Important points about CHECK CONSTRAINT in Oracle SQL / PLSQL: In Oracle SQL / PLSQL a CHECK CONSTRAINT can never be defined on a VIEW but only on a table. A CHECK CONSTRAINT […]