|
The syntax of writing a table is create table tablename ( columnname type, columnname type ..., primary key(keycolumn);...
|
|
Not Null Constraint, Primary Key Constraint, References Constraint, Unique Constraint...
|
|
Integrity constraints define a business rule for a column of the table. They are defined with a table and are stored as part of a table’s definition....
|
|
Oracle nested table and varrays - What is nested table? Explain the purpose of nested table - A nested table is an unordered set of data elements. These data elements are all of the same datatype.....
|
|
What are constraints?...
|
|
Define referential integrity - Referential integrity in Oracle is used to establish relationships between tables through foreign keys......
|
