oracle query to get all the tables names in a database code example

Example: oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;