Oracle views all of the user's table names, table comments, field names, field comments, NULL, field types

--oracle See all of the user's table names, table comments, field names, field comments, empty, field type SELECT DISTINCT table_column.*, table_nallable. Data_type, table_nallable.                        NULLABLE from (SELECT DISTINCT Utc.table_name table_name, utc.comments table_comments, Ucc.column_name column_name, ucc.comments column_comments from User_tab _comments UTC, User_col_comments UCC where utc.table_name = Ucc.table_name and utc.table_name not like ' %_b ' and utc.table_name not like '%_z ' and Utc.table_name ' don't like '%1% ') Table_column, (select           DISTINCT table_name, COLUMN_NAME, nullable, data_type from User_tab_cols where table_name don't like '%_b ' and table_name not like '%_z ' and table_name don't like '%1% ') table_nallable where table_column.column_ Name = Table_nallable.column_name and Table_column. table_name = Table_nallable.table_name--and table_column.column_comments like '% category name% ' and table_column.table_comments like '% dictionary% ';--Multiple removal of Descartes 

Oracle views all of the user's table names, table comments, field names, field comments, NULL, field types