| ankur |
Posted: Dec 05, 2006 03:55:01 AM |
Total Post: 59
Joined: Nov, 2006
|
if v hav primary key in a table.......
then is there any query from which v can see
how many dependencies are there corresponding to this primary key???
n also is there any guy wrking or wrked in Oracle9i Interconnect? |
|
|
 Prakash |
| Posted: Dec 05, 2006 05:22:57 AM |  |
|
Total Post: 112
Joined: Aug, 2006
|
you can use dba_constraints view to view the constraints,constraint_type on a table.
And Dba_cons_columns to view the columns of a table with the constraint.
|
|
|
|
|
| ankur |
| Posted: Dec 05, 2006 05:37:37 AM | |
|
Total Post: 59
Joined: Nov, 2006
|
suppose v hav a table A1(n1 as primary key)
two tables b1(n2 as forein key referencing a1.n1)
b2(n3 as forein key referencing a1.n1)
so here how can find n2 and n3 from that view .relating with a1 table.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
