Select max(SYS_CONNECT_BY_PATH(COLUMN_NAME, ', '))
From (select A.COLUMN_NAME, A.TABLE_NAME, ROWNUM AS ROWNO
from USER_TAB_COLUMNS A
where TABLE_NAME = 'test_table
ORDER BY A.COLUMN_ID)
start with ROWNO = 1
connect by ROWNO = rownum;
快速获取ORACLE表字段的清单
最新推荐文章于 2021-04-07 07:52:45 发布