Home » SQL & PL/SQL » SQL & PL/SQL » Complete tree
Complete tree [message #283084] Mon, 26 November 2007 01:29 Go to next message
nmblr
Messages: 6
Registered: November 2007
Junior Member
No Message Body

[Updated on: Mon, 26 November 2007 05:06]

Report message to a moderator

Re: Complete tree [message #283098 is a reply to message #283084] Mon, 26 November 2007 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SYS_CONNECT_BY_PATH
CONNECT_BY_ISLEAF Pseudocolumn

Regards
Michel
Re: Complete tree [message #283112 is a reply to message #283098] Mon, 26 November 2007 02:46 Go to previous messageGo to next message
nmblr
Messages: 6
Registered: November 2007
Junior Member
No Message Body

[Updated on: Mon, 26 November 2007 05:06]

Report message to a moderator

Re: Complete tree [message #283116 is a reply to message #283112] Mon, 26 November 2007 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:

The Expect result is as follows:
A,B,C,H,F,G,I

Quote:

But I am looking for
something as following

A
B
C
H
F
G
I

Do you know what you want?

Regards
Michel
Re: Complete tree [message #283120 is a reply to message #283116] Mon, 26 November 2007 02:59 Go to previous messageGo to next message
nmblr
Messages: 6
Registered: November 2007
Junior Member
No Message Body

[Updated on: Mon, 26 November 2007 05:06]

Report message to a moderator

Re: Complete tree [message #283131 is a reply to message #283120] Mon, 26 November 2007 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why a simple "connect by" does not fit your requirements?

Regards
Michel
Re: Complete tree [message #283132 is a reply to message #283131] Mon, 26 November 2007 03:15 Go to previous messageGo to next message
nmblr
Messages: 6
Registered: November 2007
Junior Member
No Message Body

[Updated on: Mon, 26 November 2007 05:05]

Report message to a moderator

Re: Complete tree [message #283143 is a reply to message #283132] Mon, 26 November 2007 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use standard SCOTT.EMP table and post the result you want. Or post a full test case.
As we don't know your data, we can't estimate why A, B... and not D, E...

Regards
Michel
Re: Complete tree [message #283163 is a reply to message #283143] Mon, 26 November 2007 04:08 Go to previous messageGo to next message
nmblr
Messages: 6
Registered: November 2007
Junior Member
No Message Body

[Updated on: Mon, 26 November 2007 05:05]

Report message to a moderator

Re: Complete tree [message #283168 is a reply to message #283163] Mon, 26 November 2007 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post formated.

Why FORD is not in the result?

Regards
Michel
Re: Complete tree [message #283170 is a reply to message #283168] Mon, 26 November 2007 04:56 Go to previous messageGo to next message
nmblr
Messages: 6
Registered: November 2007
Junior Member
No Message Body

[Updated on: Mon, 26 November 2007 05:05]

Report message to a moderator

Re: Complete tree [message #283190 is a reply to message #283170] Mon, 26 November 2007 05:56 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Thanks to remove all your posts.
Now we know it is useless to answer you.

Regards
Michel
Previous Topic: Creating multiple level nested tables (merged 2 threads)
Next Topic: cursor with parameter
Goto Forum:
  


Current Time: Tue Feb 11 03:36:32 CST 2025