Oracle Get table comments and column comments

All tables

Select  from // tables      owned by the current user Select  from //  Selectfrom// including system tables

Notes for Tables

Select *  from // comments for the current user owning the table Select *  from // comments for all user tables Select *  from // comment dba_tab_comments for all user tables, all_tab_comments One more ower column than user_tab_comments

Comments for columns

Select *  from user_col_comments; Select *  from dba_col_comments; Select *  from all_col_comments and Dba_col_comments,all_col_comments, these two are more than user_col_comments ower column

Oracle Get table comments and column comments