Query All Tables by User in PL/SQL

In PL/SQL, you can query all tables under a user by using the following query statement.

SELECT table_name 
FROM all_tables 
WHERE owner = 'username';

In this case, ‘username’ is the username of the user to be queried. This query will return the table names of all tables under the specified user. You can execute this query in PL/SQL development tool to get the desired results.