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.
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!