SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hierarchical query with out using Connect by prior

Rajan SwNov 14 2013 — edited Nov 14 2013

Hi Guys,

I am supporting a product which is enterprise based and only allowd to write queries which are ANSII standard.

I have an requirement like If I provide the child I need to know all the parents till highest level.

My table structure is like below

Table_name : Org_unit

Columns are

Org_unit_id name desc parent_org_unit_id

I wil pass the org_unit id and want to list all the parents of the chile org_unit_id and it has to be accomplished without using connec by prior.

Please suggest me some ideas and aprroches

I am using Orcle 11g version

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2013

Added on Nov 14 2013

12 comments

6,333 views