Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> A simple select question

A simple select question

From: Abiy Alemu <abiy_at_biotec.jouy.inra.fr>
Date: Tue, 10 Nov 1998 13:26:01 +0100
Message-ID: <Pine.SOL.3.91.981110132517.1919B-100000@biotec>


I have the following three tables
Tab_W Tab_X Tab_Y Tab_Z
====== ====== ====== =============
No_W No_X No_Y No_Z
Name_W No_W No_X No_X

        Name_X Name_Y Name X

With Values

Tab_W(0001,W1)
Tab_W(0002,W2)
Tab_X(0010,0001,X1)
Tab_X(0011,0001,X2)
Tab_Y(0100,0010,Y1)
Tab_Y(0101,0010,Y2)
Tab_Y(1000,0100,Z1)
Tab_Y(1001,0100,Z2)
Tab_Y(1002,0100,Z2)


And I would like to have a listing in a hierarchical mode as follows

Level		Name1		Name2
======	=======	======
1		W1		X1
2		X1		Y1
3		Y1		Z1
3		Y1		Z2
3		Y1		Z3
1		W1		X2
2		X1		Y2		

How can I do it ?

|-----------------------------------------------------------------------------|

| If the only tool you have is a | Abiy Alemu abiy_at_biotec.jouy.inra.fr |
| hammer, everything in the world | 9, avenue calmels |
| seems like a nail.____________________| 92270 Bois colombes (France)________|
Received on Tue Nov 10 1998 - 06:26:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US