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

14 votes194 views2 answers
Oracle add attribute to table
SQL
6 votes174 views1 answer
What is where clause in sql
SQL
0 vote171 views1 answer
Char varchar nvarchar sql
SQL
0 vote167 views1 answer
Postgres float to int
SQL
1 vote230 views1 answer
Sql query row number group by
SQL
0 vote256 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
2 votes245 views3 answers
Postgres create view
SQL
0 vote165 views1 answer
How to search query in python3 sqlite3
SQL
25 votes202 views6 answers
Import database mysql command line
SQL
2 votes177 views2 answers
Run mysql command from bash
SQL