How to query all tables in oracle database

Method: 1. Execute the "select * from all_tables where owner='VTATEST';" statement; 2. Execute the "select * from user_tables;" statement; 3. Execute "select * from tabs;".

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

All tables in the Oracle query database

Method 1:

select * from all_tables where owner='VTATEST';

all_tables Check out Check the tables under all users, including the tables you log in with, and then add where to the user name you want to check. (Remember to capitalize the user name)

Method 2:

select * from user_tables;

The query is only for the tables under the user you are logged in, and tables under other users will not be displayed. .

Method three:

select * from tabs;

This is the same as the second class, but the writing is simpler, and it also checks the table under the user you are in.

Recommended tutorial: "Oracle Tutorial"

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