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

10 votes154 views4 answers
Drop primary key
SQL
2 votes144 views1 answer
Mysql query unique column
SQL
2 votes144 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote153 views1 answer
Mysql config address
SQL
0 vote142 views2 answers
Update information in a mysql column
SQL
-1 vote158 views2 answers
Postgresql get last 10 records
SQL
0 vote152 views1 answer
Move table to a different schema
SQL
-2 votes159 views1 answer
Modify column name in tsql
SQL
1 vote227 views1 answer
SQL server query column yes or no
SQL
0 vote158 views1 answer
Oracle list datafiles
SQL