Check out example codes for "oracle all tables". It will help you in understanding the concepts better.

Code Example 1

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Code Example 2

SELECT
  table_name, owner
FROM
  all_tables
ORDER BY
  owner, table_name

Learn ReactJs, React Native from akashmittal.com