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

5 votes153 views2 answers
Oracle list columns
SQL
0 vote170 views1 answer
Display all node label neo4j
SQL
0 vote127 views1 answer
Postgres jsonb array push new element
SQL
-1 vote175 views5 answers
Left join
SQL
2 votes127 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote135 views1 answer
Sql update subtract value
SQL
5 votes118 views1 answer
Sql first day of current year
SQL
2 votes133 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote123 views1 answer
Mysql select month and year
SQL
12 votes126 views2 answers
Select into insert sql server
SQL