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
)
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
)
扫一扫
3204
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
