Home » Developer & Programmer » Forms » hierarchical tree and ordering
hierarchical tree and ordering [message #85129] Thu, 03 June 2004 13:00 Go to next message
Son
Messages: 5
Registered: March 2004
Junior Member
Need help

I have a table call org_code as below

  

- ORG_CODE -
- ORG_LEVEL -

- MCB -
- 1 -

- MCBXXX -
- 2 -

- MCB FF -
- 1 -

- MCB/BBB -
- 1 -

     

I have a hierarchical tree built from this table.  SQL shown below

select -1, level, substr(org_code, decode(org_level, 1, 1, instr(org_code, '' ,1, org_level-1)+1)), '', org_code

from org_code

start with org_level = 1

connect by prior org_code = substr(org_code, 1, decode(org_level, 1, 0, instr(org_code, '' ,1, org_level-1)-1))

order by org_code

We get a tree as shown below

-MCB

-MCB FF

-MCB/BBB

&#124_ MCBXXX

 

What we expect is

-MCB

&#124_ MCBXXX

-MCB FF

-MCB/BBB

 

The '' determines that MCBXXX belongs to MCB.

Due to the order by MCB FF and MCB/BBB come before MCBXXX.

 

Any suggestions would be greatly appreciated.

Thank you in advance for any help provided.

 

Report message to a moderator

Re: hierarchical tree and ordering [message #85134 is a reply to message #85129] Fri, 04 June 2004 00:51 Go to previous messageGo to next message
nsk
Messages: 16
Registered: June 2004
Junior Member
just remove order by clause from your query it will give u desire results.

best of luck.

Report message to a moderator

Re: hierarchical tree and ordering [message #85179 is a reply to message #85134] Mon, 07 June 2004 14:34 Go to previous message
Son
Messages: 5
Registered: March 2004
Junior Member
Thank you. That worked.

Report message to a moderator

Previous Topic: varray parameter from forms to oracle
Next Topic: a little bit problem!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 16:06:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.