Re: SQL query help!

"Scott" <scott_at_hcsprogramming.com> a écrit dans le message de news: 1177010577.548816.316700_at_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
|

where wbs_id = <your wbs_id>

Regards
Michel Cadot Received on Thu Apr 19 2007 - 15:38:25 CDT