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 vote217 views1 answer
Oracle db get table sizes
SQL
0 vote232 views1 answer
Initcap in mysql
SQL
0 vote222 views1 answer
Order by ip address sql
SQL
0 vote243 views1 answer
How to get nth number in sql
SQL
0 vote232 views1 answer
Tsql pad left
SQL
0 vote231 views1 answer
Flask sqlalchemy session delete
SQL
11 votes216 views1 answer
How to get ddl for materialized view
SQL
0 vote225 views1 answer
Sql make sure every user is unqiuew
SQL
2 votes220 views4 answers
How to find 2nd highest salary in mysql
SQL
6 votes246 views3 answers
Oracle all dates between two dates
SQL