What are constraints?

What are constraints?

It is the rules that prevent the invalid entry into the table. They are stored in the data dictionary. They can be defined either at column level or table level.

Following are the constraints available in oracle.

Not Null - Specifies that column can’t contain a null value.

Unique - Enforce unique value for all rows in the table.

Primary key - Uniquely identifies each row of the table.

Foreign key - Enforces a foreign key relationship between the columns of the referenced table.

Check - specifies condition that must be true.
Define referential integrity
Define referential integrity - Referential integrity in Oracle is used to establish relationships between tables through foreign keys......
Differences between char and varchar2 data types
The char data type accepts strings that are of fixed length.....
BLOB, CLOB, NCLOB are stored internally where as BFILE is stored externally....
Post your comment