Oracle statements used to query all tables of a user

The following statements are used to query all your tables in Oracle. If you are interested in Oracle queries, take a look.

Select * From all_tab_comments -- query tables and views of all users

Select * From user_tab_comments -- query the user's tables and views

Select * From all_col_comments

-- Query the column names and comments of all user tables.

Select * From user_col_comments -- query the column names and comments of the user's table.

Select * From all_tab_columns

-- Query the column names and other information of all user tables (detailed but no remarks ).

Select * From user_tab_columns

-- Query the column name and other information of the user's table (detailed but no remarks ).--

Generally, use 1:

Select T. table_name, T. Comments from user_tab_comments t --

2: Select R1, R2, R3, R5

From (select a. table_name R1, A. column_name R2, A. Comments R3 from user_col_comments ),
(Select T. table_name R4, T. Comments R5 from user_tab_comments t) Where r4 = r1
The preceding statements are used to query all tables of an Oracle database.