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