Skip to Main Content
Forums

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!

parentid childid from name

901346Jul 29 2013 — edited Jul 30 2013

Hi,

Very good morning.

I am facing a problem after searching Google and forum i am unable to construct.

I have the following table data.

I want to add id [ parent(if no parent id should null)/child(if no child id should null)] with this.

can i make this from this table based on the name.

name Par_name   hierarchy

---- ------ -----------------------------------

A                     1

B    A               2

C    B               3

D    C               4

E    C               4

G    B               3

R    B               3

P                     1

Q    P               2

R    Q               3

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2013
Added on Jul 29 2013
4 comments
511 views