posted by 구름너머
2011. 7. 4. 17:42
아래처럼 오라클9i인데 쿼리가 안먹힙니다.
해결방안 좀 충고해주세요.
--------------------------------------------------------------------------------------------------------------------------
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Jul 4 17:17:12 2011 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> SELECT LPAD(' ', 2*level-1)||SYS_CONNECT_BY_PATH(tel_ofc_name, '/') "Path"
2 FROM tb_Ofc
3 START WITH tel_ofc_name = '백령지점'
4 CONNECT BY PRIOR tel_ofc_cd = p_tel_ofc_cd;
SELECT LPAD(' ', 2*level-1)||SYS_CONNECT_BY_PATH(tel_ofc_name, '/') "Path"
*
ERROR at line 1:
ORA-00904: "SYS_CONNECT_BY_PATH": invalid identifier
|
|
| 태그 : SYS_CONNECT_BY_PATH |
