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 vote126 views1 answer
Mysql add comment to column
SQL
0 vote141 views1 answer
Mysql page segment
SQL
19 votes132 views6 answers
Laravel sql query
SQL
0 vote128 views1 answer
Postgres week number
SQL
3 votes128 views2 answers
Sql paging query
SQL
0 vote196 views1 answer
How to show current database in mysql
SQL
2 votes95 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote163 views2 answers
How to install psql in ubuntu
SQL
1 vote142 views1 answer
Sql server update column based on another table
SQL
5 votes130 views3 answers
How to remove unique key constraint in mysql
SQL