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 vote173 views1 answer
Implode in sql query
SQL
0 vote165 views1 answer
Mysql min value row
SQL
2 votes163 views1 answer
Sql count having
SQL
0 vote135 views1 answer
Dump multiple tables mysql
SQL
4 votes145 views4 answers
Start mysql
SQL
-1 vote154 views1 answer
Window functions in sql
SQL
1 vote140 views1 answer
Mysql get character set
SQL
0 vote143 views1 answer
Copy Table from SQL to CSV
SQL
1 vote164 views1 answer
How to get previous year from sysdate in oracle
SQL
1 vote151 views1 answer
Operator does not exist: integer = text
SQL