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

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);