Query all table names:
Select T.table_name from User_tables t;
Query all field names:
Select T.column_name from User_col_comments t;
Query all field names for the specified table:
Select T.column_name from user_col_comments t where T.table_name = ' biz_dict_xb ';
Query all field names and field descriptions for the specified table:
Select T.column_name, t.column_name from user_col_comments t where T.table_name = ' biz_dict_xb ';
query table names and table descriptions for all tables:
Select t.table_name,f.comments from User_tables t inner joins user_tab_comments f on t.table_name = F.table_name;
Query the table name and table description for the fuzzy table name:
Select T.table_name from User_tables t where t.table_name like ' biz_dict% ';
Select t.table_name,f.comments from User_tables t inner joins user_tab_comments f on t.table_name = F.table_name where T.ta Ble_name like ' biz_dict% ';
Oracle Query library for all table names, field names, table name descriptions, field name Descriptions (original)