ORACLE数据查询所有表和对应字段注释

最新推荐文章于 2024-11-09 16:20:10 发布

babyHuQi

最新推荐文章于 2024-11-09 16:20:10 发布

阅读量144

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/MissQi0408/article/details/109842685

版权

SELECT A.TABLE_NAME,B.COMMENTS TABLE_COMMENTS, ROW_NUMBER() OVER(PARTITION BY A.TABLE_NAME ORDER BY A.TABLE_NAME) AS RANK,

A.COLUMN_NAME, C.COMMENTS COL_COMMENTS, A.DATA_TYPE || '(' || A.DATA_LENGTH || ')' COLUMN_TYPE FROM USER_TAB_COLUMNS A LEFT JOIN USER_TAB_COMMENTS B ON A.TABLE_NAME = B.TABLE_NAME LEFT JOIN USER_COL_COMMENTS C ON A.TABLE_NAME = C.TABLE_NAME AND A.COLUMN_NAME = C.COLUMN_NAME