描述信息存在sys用户下的all_col_comments、all_tab_comments、user_col_comments、user_tab_comments这四张表中
select t.TABLE_NAME, t.COLUMN_NAME, t.COMMENTS from all_col_comments t where t.OWNER = 'MYUSER'
select t.TABLE_NAME, t.COMMENTS from all_tab_comments t where t.OWNER = 'MYUSER'
select t.TABLE_NAME, t.COLUMN_NAME, t.COMMENTS from all_col_comments t
select t.TABLE_NAME, t.COMMENTS from user_tab_comments t where where t.TABLE_TYPE = 'TABLE' --只查看table,不查看view
需注意的是owner字段里面的用户名都是大写的