Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS (DY)';
DECLARE
  does_not_exist EXCEPTION;
  PRAGMA EXCEPTION_INIT(does_not_exist, -942);
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE tmp';
  DBMS_OUTPUT.PUT_LINE('The table was dropped.');
EXCEPTION
  WHEN does_not_exist THEN
    DBMS_OUTPUT.PUT_LINE('The table did not exist.');
END;
/
1 rows affected

dbms_output:
The table did not exist.

CREATE TABLE tmp (x) AS SELECT 1 FROM DUAL;
1 rows affected

DECLARE
  does_not_exist EXCEPTION;
  PRAGMA EXCEPTION_INIT(does_not_exist, -942);
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE tmp';
  DBMS_OUTPUT.PUT_LINE('The table was dropped.');
EXCEPTION
  WHEN does_not_exist THEN
    DBMS_OUTPUT.PUT_LINE('The table did not exist.');
END;
/
1 rows affected

dbms_output:
The table was dropped.

CREATE TABLE tmp (x) AS SELECT 1 FROM DUAL;
1 rows affected

CREATE PRIVATE TEMPORARY TABLE ora$ptt_temp AS SELECT * FROM tmp;
1 rows affected

SELECT * FROM ora$ptt_temp;


X


1


COMMIT;
SELECT * FROM ora$ptt_temp;
ORA-00942: table or view does not exist