Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL query help!
Hello,
I am not very good with SQL and I was given this query that I do not know how to limit it to one wbs_id. Can someone help?
Thanks in Advance,
Scott
SELECT LEVEL xlevel
,proj_id
,wbs_short_name
,wbs_id
,parent_wbs_id
,SYS_CONNECT_BY_PATH(wbs_short_name,'.')
,REVERSE(SYS_CONNECT_BY_PATH(REVERSE(wbs_short_name),'.'))
FROM admuser.projwbs
START WITH proj_id = 1356
CONNECT BY PRIOR parent_wbs_id = wbs_id
Received on Thu Apr 19 2007 - 14:22:57 CDT