Home » SQL & PL/SQL » SQL & PL/SQL » SQL Query for Parent and child relation
SQL Query for Parent and child relation [message #205615] Sun, 26 November 2006 18:46 Go to next message
sydney1
Messages: 65
Registered: November 2006
Location: sydney
Member
Hi Gurus'

I have a problem in writing the query to display only the results that belong to the parent folder.like

Account/billing/costcentre.

i want to display the costcentre that belongs to billing group and that billing group that belogs to Account.

Could anyone help me. I am looking on orafaq site and oracle help in the mean time i thought i will post if some one can answer. as i need to give the report tomorrow.

Regards
dil
Re: SQL Query for Parent and child relation [message #205618 is a reply to message #205615] Sun, 26 November 2006 19:16 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
The homework tutor is down the hall, the 2nd door on the left.
Re: SQL Query for Parent and child relation [message #205619 is a reply to message #205618] Sun, 26 November 2006 19:20 Go to previous message
sydney1
Messages: 65
Registered: November 2006
Location: sydney
Member
Thanks for your nice reply anacedent.

I have just found the example on ORAFQAQ. I think that will solve my problem. I will try that and update the results.
Thank to all.

Regards
dil
Previous Topic: Procedure inside the Package
Next Topic: Procedure
Goto Forum:
  


Current Time: Sat Dec 10 03:26:10 CST 2016

Total time taken to generate the page: 0.10926 seconds