find tables in database using pl sql code example Example: oracle all tables -- NOTE: for Oracle ONLY select * from all_tables;