oracle 查询当前用户下所有表结构信息 

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

 

posted @ 2017-08-30 11:12  liushengit  阅读(486)  评论(0)    收藏  举报