select t1.owner ,t1.table_name ,t1.column_id ,t1.column_name ,t1.data_type ,t2.comments from all_tab_columns t1 join all_col_comments t2 on t1.owner = t2.owner and t1.table_name = t2.table_name and t1.column_name = t2.column_name where t1.owner not like '%SYS%' ;
select t1.owner ,t1.table_name ,t3.comments as table_comment ,t3.table_type ,t1.column_id ,t1.column_name ,t1.data_type ,t2.comments as column_comment from all_tab_columns t1 join all_col_comments t2 on t1.owner = t2.owner and t1.table_name = t2.table_name and t1.column_name = t2.column_name join all_tab_comments t3 on t1.owner = t3.owner and t1.table_name = t3.table_name where t1.owner not like '%SYS%' ;