In which table / view is the query requested to select all table names in the schema in Oracle?

What object do you request to select all table names in a schema in Oracle?

+3
source share
3 answers

To view all the tables that you have access to

select table_name from all_tables where owner='<SCHEMA>';

To select all tables for the current input schema (e.g. your tables)

select table_name from user_tables;
+5
source

which you are looking for:

select table_name from user_tables;
+1
source

you can use

select tab tab from

to get the name of the tables present in the schema.

-1
source

Source: https://habr.com/ru/post/1696743/


All Articles