查看comment

 --查看表的comment  
  select   *   from   all_tab_comments   where   table_name='大写表名';  
   
  --查看列的comment  
  select   *   from   all_col_comments   where   table_name='大写表名';