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 vote316 views1 answer
Min varias colunas spark sql
SQL
0 vote287 views2 answers
Oracle create tablespace autoextend
SQL
1 vote297 views2 answers
One to one and one to many relationship
SQL
0 vote263 views1 answer
Create new table pl sql
SQL
1 vote289 views1 answer
Mysql select from outside
SQL
12 votes304 views6 answers
Distinct in sql server
SQL
0 vote281 views1 answer
SQL SELECT-Klausel
SQL
0 vote287 views1 answer
How to query without duplicate rows in sql
SQL
0 vote266 views1 answer
Sql select min row
SQL
5 votes269 views2 answers
Mysql drop table cascade
SQL