What is an integrity constraint?
What is an integrity 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.
Types of integrity constraints supported by oracle are: NOT NULL integrity constraint Unique Key integrity constraint Primary Key integrity constraint Foreign key integrity constraint Check integrity constraint
|
Oracle nested table and varraysOracle 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.....
Define referential integrityDefine referential integrity - Referential integrity in Oracle is used to establish relationships between tables through foreign keys......