Oracle Query library for all table names, field names, field name descriptions, query table data bar number, table name, Chinese table name,

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 name and table description for all tables:
Select t.table_name,f.comments from user_tables t inner join user_tab_comments f on t.table_name = F.tabl E_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% ';

--Query table data bar number, table name, Chinese table name
Select A.num_rows, A.table_name, b.comments
from User_tables A, user_tab_comments b
WHERE a.table_name = b.table_name
ORDER BY table_name;

 

All table names, field names, field name descriptions in the Oracle query library, number of data bars in the query table, table name, Chinese table name,