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%'

;