How to query all user tables in oracle

In Oracle, you can use the select statement to query all user tables. This statement is used to select data from the database. You can use "all_tab_comments" to represent all user tables and views. The syntax is "select * from all_tab_comments. ".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How oracle queries all user tables

The SELECT statement is used to select data from the database.

The results are stored in a result table, called a result set.

SQL SELECT syntax

SELECT column_name,column_name
FROM table_name;

and

SELECT * FROM table_name;

query the tables and views of all users, the syntax is as follows:

select * from all_tab_comments

Expand knowledge:

Query this user’s tables, views, etc.

select * from user_tab_comments

Oracle Video Tutorial 》

The above is the detailed content of How to query all user tables in oracle. For more information, please follow other related articles on the PHP Chinese website!