查看表的描述信息select * from all_tab_comments where table_name = 'XXX'

查看列的描述信息select * from all_col_comments where table_name = 'XXX'