| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Plan_Table problem
I am attempting to develop a script but encountered problems testing the results of my sql statement. I am getting strange results using CONNECT BY PRIOR command. Assistance is needed!!
SELECT LPAD(' ',LEVEL-1)||OPERATION||' '||OPTIONS||' '||OBJECT_NAME
Query_plan
FROM PLAN_TABLE
CONNECT BY PRIOR ID = PARENT_ID
START WITH parent_id IS NULL
ORDER BY ID;
Kevin
Received on Wed Apr 01 1998 - 00:00:00 CST
 |
 |