ordering within a hierarchy:

I have the following query:
 SELECT LEVEL, SEQ_NO, RPAD(' ', LEVEL *5) || CHILD_ACCOUNT, PARENT_ACCOUNT FROM GL_GROUP_BOM
 CONNECT BY PRIOR CHILD_ACCOUNT = PARENT_ACCOUNT  START WITH PARENT_ACCOUNT = 'STAT_DEPT_EXPSE'; which returns the following...

1	10	     COMP_RELTD_COST	STAT_DEPT_EXPSE
2	10	          55000	COMP_RELTD_COST
2	11	          55040	COMP_RELTD_COST
2	12	          55001	COMP_RELTD_COST
2	15	          55015	COMP_RELTD_COST
2	20	          55099	COMP_RELTD_COST
2	25	          55500	COMP_RELTD_COST
2	28	          55550	COMP_RELTD_COST
2	30	          55035	COMP_RELTD_COST
2	32	          55030	COMP_RELTD_COST
2	34	          55020	COMP_RELTD_COST
2	36	          55021	COMP_RELTD_COST
2	40	          55028	COMP_RELTD_COST
2	42	          55250	COMP_RELTD_COST
2	44	          55025	COMP_RELTD_COST
2	46	          55005	COMP_RELTD_COST
2	48	          55999	COMP_RELTD_COST
2	26	          55510	COMP_RELTD_COST
2	27	          55520	COMP_RELTD_COST
1	20	     OCCUPANCY_COSTS	STAT_DEPT_EXPSE
2	10	          52000	OCCUPANCY_COSTS
2	12	          52001	OCCUPANCY_COSTS
2	14	          52010	OCCUPANCY_COSTS
2	16	          52015	OCCUPANCY_COSTS
2	18	          52017	OCCUPANCY_COSTS
2	20	          52004	OCCUPANCY_COSTS
2	22	          52011	OCCUPANCY_COSTS

within the hierarchy - I would like to be able to sort: note that seq_no's 26 and 27 are following number 48. I also want to insure that my level one stays in order by sequence number as well.

any suggestions? thanks.
glenn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 13 1998 - 09:42:29 CDT