快速获取ORACLE表字段的清单

最新推荐文章于 2025-01-07 09:26:27 发布

sevencash

最新推荐文章于 2025-01-07 09:26:27 发布

阅读量495

点赞数

CC 4.0 BY-SA版权

文章标签： oracle table path user

本文链接：https://blog.youkuaiyun.com/sevencash/article/details/4041330

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;