how to show list of tables in sql oracle code example

Example: show all tables in oracle

SELECT * FROM ALL_TABLES;