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

4 votes282 views1 answer
W3schools create table
SQL
1 vote254 views1 answer
Nested if in mysql
SQL
0 vote256 views1 answer
Mysql command line ubuntu
SQL
0 vote252 views1 answer
If null don't update
SQL
0 vote300 views1 answer
Error code 1451 sql
SQL
1 vote275 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
15 votes265 views2 answers
Select Options
SQL
1 vote267 views1 answer
Sql run multiple updates in one query
SQL
0 vote274 views1 answer
How to check which table has data in mysql
SQL
1 vote262 views1 answer
Local sql server
SQL