View all tables and fields and table comments in Oracle. Field comments

Select table_name from User_tables; Tables owned by the current user       select table_name from all_tables;//Table of all users select table_name from Dba_tables;//Includes system table Select table_name FR Om dba_tables where owner= ' user name ' user_tables:table_name,tablespace_name,last_analyzed, etc. dba_tables:ower,table_name, Tablespace_name,last_analyzed et all_tables:ower,table_name,tablespace_name,last_analyzed et all_objects:ower,object _name,subobject_name,object_id,created,last_ddl_time,timestamp,status, etc.

Get table field:

SELECT * from user_tab_columns where table_name= ' user table '; select * from All_tab_columns where table_name= ' user table '; select * from D Ba_tab_columns where table_name= ' user table '; user_tab_columns:table_name,column_name,data_type,data_length,data_ Precision,data_scale,nullable,column_id et All_tab_columns:ower,table_name,column_name,data_type,data_length,data _PRECISION,DATA_SCALE,NULLABLE,COLUMN_ID and other Dba_tab_columns:ower,table_name,column_name,data_type,data_length, DATA_PRECISION,DATA_SCALE,NULLABLE,COLUMN_ID, etc.

Get Table Comments:

SELECT * from user_tab_commentsuser_tab_comments:table_name,table_type,comments the corresponding dba_tab_comments,all_tab_ Comments, these two are more than user_tab_comments ower column. Get field Comment: SELECT * from User_col_commentsuser_col_comments:table_name,column_name,comments
The corresponding dba_col_comments,all_col_comments, the two more than the User_col_comments ower column.

View all tables and fields and table comments in Oracle. Field comments