Explain the constraints that can be applied to Oracle tables.

Answer

The syntax of writing a table is

Code:

create table tablename ( columnname type, columnname type ..., primary key(keycolumn);

The keycolumn is associates with the key constraint.

You can even add the foreign key constraint by adding the references to the table for that foreign key in the following way:

foreign key(column) references foreigntable