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 RAID technology?which is better RAID 0+1 OR RAID 5?
Explain about integrity constraint?
Can the default values be assigned to actual parameters?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
12. Display the client name in upper case only and in lower case only.
Can you use a commit statement within a database trigger?
How to install oracle odbc drivers?
Explain alias?
How to use "if" statements on multiple conditions?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is truncate oracle?
What is oracle analytical function?