Oracle sees all of the user's table names, table gaze, field names, field gaze, empty, field type

--oracle See all the user's table names, table gaze, field name, field gaze, is 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% ';--Descartes repeatedly deleted 

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

Oracle sees all of the user's table names, table gaze, field names, field gaze, empty, field type