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 vote268 views1 answer
Sql delimiter to columns
SQL
0 vote271 views1 answer
Mysql database hyphen
SQL
1 vote347 views1 answer
Difference between where and having clause
SQL
0 vote272 views1 answer
Mysql select field if condition
SQL
1 vote288 views2 answers
Maximum number of tables in mysql
SQL
2 votes263 views1 answer
Sql skip the first row
SQL
0 vote264 views1 answer
Mysql_error replacement
SQL
0 vote290 views1 answer
Kill slow queries mysql
SQL
2 votes284 views1 answer
Sqlite3 show columns name
SQL
0 vote711 views2 answers
Zsh: command not found: mysq
SQL