Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order siblings by

2947022May 30 2015 — edited May 30 2015

Hi All,

I am using

Connected to Oracle Database 11g Express Edition Release 11.2.0.2.0

I am using Oracle scott schema

SQL> SELECT LPAD(' ',(LEVEL-1)*2,' ') || ENAME ENAME

  2  FROM EMP

  3  START WITH MGR IS NULL

  4  CONNECT BY PRIOR EMPNO=MGR

  5  ORDER SIBLINGS BY ENAME

  6  ;

SELECT LPAD(' ',(LEVEL-1)*2,' ') || ENAME ENAME

FROM EMP

START WITH MGR IS NULL

CONNECT BY PRIOR EMPNO=MGR

ORDER SIBLINGS BY ENAME

ORA-00976: Specified pseudocolumn or operator not allowed here.

I am not able to understand where i am making mistake.

Please help

Thanks,

This post has been answered by Frank Kulash on May 30 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2015
Added on May 30 2015
2 comments
798 views