SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
An uncaught error happened in fetching the records : ORA-30929: ORDER SIBLINGS BY clause not allowed here
ORA-30929: ORDER SIBLINGS BY clause not allowed here
2 rows selected.
Fairly complex query, Oracle 9.2.0.5 on Sparc Solaris 8.
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
Ours is the age that is proud of machines that can think and suspicious of men who try to. --H. Mumford Jones, 1892-1980