기본 콘텐츠로 건너뛰기

9월, 2012의 게시물 표시

테이블의 칼럼명을 콤마로 분리하여 출력

SELECT SUBSTR(COL,2,LENGTH(COL)) FROM( SELECT MAX(SYS_CONNECT_BY_PATH (COLUMN_NAME, ',')) AS "COL" FROM ( SELECT ROWNUM ROW_NUM,COLUMN_NAME FROM ( select COLUMN_NAME FROM all_tab_columns where owner= {DATABASE_NAME} AND TABLE_NAME = {TABLE_NAME} )) START WITH ROW_NUM = 1 CONNECT BY PRIOR ROW_NUM = ROW_NUM - 1);