Get list of tables in Oracle using user_tables
You can get the list of all tables in an Oracle database by executing the following SQL statement:
SELECT table_name FROM user_tables;
This will return the list of all tables owned by the current user.
If you want to see the tables in all schemas, you can use the following SQL statement:
SELECT owner, table_name FROM all_tables;
{{ 'Comments (%count%)' | trans {count:count} }}
{{ 'Comments are closed.' | trans }}