How to query all tables in oracle

oracle queries all tables under the current user name

select * from all_tables where owner='TEST'；

TEST is the user name, and the user name must be in uppercase.

View the table of currently logged in users:

select table_name from user_tables;

Oracle related introduction:

Oracle Corporation, the full name is Oracle Corporation (Oracle Software Systems Co., Ltd.), It is the world's largest enterprise software company, headquartered in Redwood Beach, California, USA. Officially entered the Chinese market in 1989. In 2013, Oracle surpassed IBM and became the world's second largest software company after Microsoft. [

Recommended tutorial: "Oracle Tutorial"

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