Re: pb with sql hierarchical queries

guerillot g <gg200492_at_club-internet.fr> wrote (in <3541F049.BB9617AF_at_club-internet.fr>)...

| HIERARCHY:
| 1
|
| 2 3 4
|
| 5 6 7 8 9 10 11 12
|
| 13 14 15 16 17 18 19 20 21 22
|
| WHAT IS THE SQL CODE TO WRITE FOR OBTAIN IN HIERARCHICAL QUERIES
| THE FOLLOWING RESULT:
| LEVEL 2 LEVEL4
| 2 13
| 2 14
| 2 15
| 2 16
| 2 17
| 2 18
| 3 19
| 3 20
| 3 21
| 4 22

Hello,
  Are you are aware that posting in UPPERCASE is considered shouting at people?
 So basically you have just demanded that someone post an answer for you!
 It should be interesting to see how many replies you get which provide helpful answers.

I suggest that more information as to why you want the answer. You wouldn't be a student would you?

A hint for you:
 Look at 'CONNECT BY', 'PRIOR' and 'START WITH' (Oracle reserved words) for the answer to your query.
 You also should provide us with your table definition.

graham Received on Sat Apr 25 1998 - 09:34:07 CDT