oracle 查询当前用户下所有表结构信息
时间:2017-08-30 11:30:13
收藏:0
阅读:429
1 select t.table_name,cm.comments, c.COLUMN_NAME,ccm.comments 2 from user_tables t 3 left join user_tab_columns c on c.TABLE_NAME = t.table_name 4 left join user_tab_comments cm on cm.table_name=t.table_name 5 left join user_col_comments ccm on ccm.table_name=c.TABLE_NAME and ccm.column_name=c.COLUMN_NAME 6 order by t.table_name asc ,c.COLUMN_NAME
原文:http://www.cnblogs.com/liushengit/p/7452131.html
评论(0)