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

1 vote222 views1 answer
Round one decimal place mysql
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL
17 votes249 views6 answers
Sql current date
SQL
0 vote240 views1 answer
Postgresql conectar
SQL
0 vote147 views2 answers
Postgresql could not start server mac
SQL
5 votes166 views2 answers
Create table
SQL
0 vote169 views2 answers
How to start postgresql laravel
SQL
2 votes201 views1 answer
Oracle find unusable indexes
SQL
3 votes187 views4 answers
Show databases in sql server
SQL
0 vote276 views1 answer
Modificar tipo de dato sql server
SQL