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

11 votes351 views1 answer
Sql insert multiple rows from select
SQL
19 votes331 views1 answer
Sqrt(-1)
SQL
0 vote367 views1 answer
Oracle execute package dblink
SQL
1 vote345 views2 answers
Update with inner join sql server
SQL
2 votes346 views1 answer
Sql create database
SQL
0 vote352 views1 answer
Mysql regex select
SQL
1 vote342 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote376 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote372 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote369 views1 answer
Search In the Database using Text
SQL