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,