Query Oracle Tables by User

To search for all tables under a specific user (such as SCOTT), you can use the following SQL statement:

SELECT table_name
FROM all_tables
WHERE owner = 'SCOTT';

If you want to retrieve all tables under the current user, you can use the following SQL statement:

SELECT table_name
FROM user_tables;

Additionally, if you want to query all tables under all users, you can use the following SQL statement:

SELECT owner, table_name
FROM all_tables;