Describe Referential Integrity ?
Answer / orawhiz
A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to be
performed on dependent data as a result of any action on
referenced data.
Is This Answer Correct ? | 4 Yes | 0 No |
What is a read write transaction in oracle?
How to create a new table in oracle?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What is a subquery in oracle?
Can you use a commit statement within a database trigger?
What is SAVE POINT ?
how do u know the total no of rows in a table?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
how do get database name at sql prompt?
Explain the use of analyse option in exp command.
What are triggers in oracle?