oracle查看表，表字段的诠释

分类: IT文章 • 2024-12-18 13:54:42

oracle查看表，表字段的注释
SELECT * from(
SELECT test.table_name,test.comments as

tableName,colComment.column_name,colComment.comments AS columnName from (
SELECT tablecomments.* FROM user_tables tab INNER JOIN user_tab_comments tablecomments ON

tab.TABLE_NAME=tablecomments.TABLE_NAME ORDER BY tab.TABLE_name
)test INNER JOIN user_col_comments colComment on colComment.TABLE_NAME=test.TABLE_NAME
)