OraFAQ Forum: SQL & PL/SQL » Finding the Parent Child Relationship between tables

Home » SQL & PL/SQL » SQL & PL/SQL » Finding the Parent Child Relationship between tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Finding the Parent Child Relationship between tables [message #194526]

Fri, 22 September 2006 09:06

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

Report message to a moderator

Re: Finding the Parent Child Relationship between tables [message #194619 is a reply to message #194526]

Sat, 23 September 2006 01:13

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

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

Report message to a moderator

Re: Finding the Parent Child Relationship between tables [message #194624 is a reply to message #194622]

Sat, 23 September 2006 01:32

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

Report message to a moderator

Previous Topic:	Bad Left Outer Join Optimisation
Next Topic:	Query to find duplicate records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 17:33:19 CST 2024