Home » SQL & PL/SQL » SQL & PL/SQL » Finding the Parent Child Relationship between tables
Finding the Parent Child Relationship between tables [message #194526] Fri, 22 September 2006 09:06 Go to next message
Gayathri80
Messages: 1
Registered: September 2006
Junior Member
Hi Friends,

Could you please let me know how to find the Parent/Child relationship between the tables.

Kindly let me know what Oracle/Sql command i need to get the same.

Thanks and regards,
Gayathri
icon2.gif  Re: Finding the Parent Child Relationship between tables [message #194619 is a reply to message #194526] Sat, 23 September 2006 01:13 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Google is your best friend

something related to what you asked here

i got this link in the first result in google.

[Updated on: Sat, 23 September 2006 01:14]

Report message to a moderator

Re: Finding the Parent Child Relationship between tables [message #194622 is a reply to message #194526] Sat, 23 September 2006 01:26 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Amul is wright to say "Google is your best friend"

But he misleaded to the link ...

@Gayathri80 :

Just one tip :

You can refer USER_CONSTRAINTS , USER_CONS_COLUMNS for this
to get Parent/Child relationship between the tables with is user .

Thumbs Up
Rajuvan
Re: Finding the Parent Child Relationship between tables [message #194624 is a reply to message #194622] Sat, 23 September 2006 01:32 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
oops that might have been a mistake.but connect by clause is used to denote the hierarchy.i apologize
Previous Topic: Bad Left Outer Join Optimisation
Next Topic: Query to find duplicate records
Goto Forum:
  


Current Time: Thu Dec 08 14:20:06 CST 2016

Total time taken to generate the page: 0.08793 seconds