how to view all tables present in sql oracle code example Example: show all tables in oracle SELECT * FROM ALL_TABLES;