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 * fromall_tab_commen

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_commen

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.

,