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 vote333 views1 answer
Month mysql
SQL
0 vote320 views1 answer
Dump only schema
SQL
0 vote353 views1 answer
Get who is hired in february in sql
SQL
0 vote352 views1 answer
Normalization in database 2nd normal form
SQL
0 vote412 views1 answer
Generate sql from specific migration ef core
SQL
0 vote367 views1 answer
Copying query result to excel
SQL
0 vote341 views3 answers
Get free card roblox
SQL
1 vote324 views1 answer
Mysql average of multiple columns
SQL
8 votes386 views3 answers
SQL column name
SQL
10 votes350 views5 answers
Between keyword in sql
SQL