View all tables and fields in Oracle

Get table field:

SELECT *
From User_tab_columns
where table_name= ' user table '
ORDER BY column_name

Get Table Comments:

SELECT *
From User_tab_comments
where table_name= ' user table '

ORDER BY table_name

Get field Comments:

SELECT *
From User_col_comments
where table_name= ' user table '

ORDER BY column_name

/* Get table: */

Select table_name from User_tables; The current user's table

Select table_name from All_tables; All users ' tables

Select table_name from Dba_tables; including system tables

Select table_name from dba_tables where owner= ' Zfxfzb '

/*
User_tables:

Table_name,tablespace_name,last_analyzed, etc.

Dba_tables:

Ower,table_name,tablespace_name,last_analyzed, etc.

All_tables:

Ower,table_name,tablespace_name,last_analyzed, etc.

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 dba_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, etc.

All_tab_columns:

OWER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE,COLUMN_ID, etc.

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_comments

/*
User_tab_comments:table_name,table_type,comments

The corresponding dba_tab_comments,all_tab_comments, the two more than the User_tab_comments ower column.
*/

/* Get field Comments: */

SELECT * FROM User_col_comments

/*

User_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 in Oracle