list tables in plsql code example Example: oracle all tables -- NOTE: for Oracle ONLY select * from all_tables;