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 -> SQL query help!

SQL query help!

From: Scott <scott_at_hcsprogramming.com>
Date: 19 Apr 2007 12:22:57 -0700
Message-ID: <1177010577.548816.316700@e65g2000hsc.googlegroups.com>


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

Original text of this message

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