Question

How will you view all the tables in the database named company

Answer 1

If you wish to get view your tables or the tables that you own SELECT * FROM user tables;

To get each and every  tables and the other tables that you have access to from other Schemes(s):SELECT * FROM all users;

To get a View to all the tables present  in your Oracle DB instance:SELECT * from dba_users;

At the end of all,  SELECT requires special advantage  from DBA just in case the query not been accessed by you.