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 name and comment 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, 1 is used:
Select t. table_name, t. comments from user_tab_comments t

-- Generally 2 is used:
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.

Oracle with statement usage

Implementation of Oracle query of user tablespace

How to improve the efficiency of Oracle databases

Oracle index Optimization Design

16 oracle query date statements