17,090
社区成员
发帖
与我相关
我的任务
分享
SQL> WITH SCOTT_EMP(EMPNO,MGR,ENAME,T) AS(
2 SELECT EMPNO,MGR,ENAME,0 T FROM EMP WHERE MGR IS NULL
3 UNION all
4 SELECT E.EMPNO,E.MGR,E.ENAME,M.T+1 FROM EMP E
5 INNER JOIN SCOTT_EMP M ON E.MGR=M.EMPNO
6 )
7 SELECT * FROM SCOTT_EMP;
WITH SCOTT_EMP(EMPNO,MGR,ENAME,T) AS(
*
ERROR at line 1:
ORA-32033: unsupported column aliasing
SQL>