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 |
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to write text literals in oracle?
what is index?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
How to turn on or off recycle bin for the session?
What is define in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain what are clusters?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to save query output to a local file?
How view is different from a table?
What is a recycle bin in oracle?