Oracle drop temporary table

CREATE OR REPLACE PROCEDURE p AS
    table_or_view_not_exist EXCEPTION;
    PRAGMA EXCEPTION_INIT (table_or_view_not_exist, -942);
    attempted_ddl_on_in_use_GTT EXCEPTION;
    PRAGMA EXCEPTION_INIT (attempted_ddl_on_in_use_GTT, -14452);
BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE t';

EXCEPTION
    WHEN table_or_view_not_exist THEN
        dbms_output.put_line('Table t did not exist at drop time. Continuing.');

    WHEN attempted_ddl_on_in_use_GTT THEN
        dbms_output.put_line('Help ! Someone is doing my job!');
        dbms_output.put_line('Please rescue me');
        RAISE;
END p;

Source: stackoverflow.com

Similar codes

0 vote180 views3 answers
Java hide mysql login credentials
SQL
3 votes180 views2 answers
Mysql create timestamp column
SQL
1 vote169 views1 answer
Ora-01950 no privileges on tablespace
SQL
1 vote162 views1 answer
Mysql remove last empty newline
SQL
0 vote178 views1 answer
How to open mysql in docker
SQL
-1 vote176 views1 answer
Sql set max value in column
SQL
14 votes213 views6 answers
Finding duplicate rows mysql
SQL
4 votes165 views4 answers
Sqlite describe table
SQL
4 votes174 views1 answer
Id increment ms sql server
SQL
0 vote174 views1 answer
Oracle SQL join three tables and group by column
SQL