What is self-referential integrity constraint ?
Answer Posted / orawhiz
If a foreign key reference a parent key of the same table is
called self-referential integrity constraint
| Is This Answer Correct ? | 36 Yes | 3 No |
Post New Answer View All Answers
What are the differences between interval year to month and interval day to second?
What is tns service name?
How to create a new oracle data file?
Why do you create or replace procedures rather that drop and recreate.
How to rename a column in an existing table?
How to pass a parameter to a cursor in oracle?
How to list all indexes in your schema?
Point out the difference between user tables and data dictionary?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Can the query output be sorted by multiple columns in oracle?
How to call a sub procedure?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to get maxsal , minsal, ename department wise in single query