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 vote282 views2 answers
Create sequence if not exists postgres
SQL
0 vote281 views2 answers
Sql drop view if exists
SQL
0 vote276 views1 answer
Python mysql executemany
SQL
0 vote269 views1 answer
Mariadb LOAD DATA INFILE
SQL
1 vote278 views1 answer
Real world example of nosql
SQL
6 votes276 views1 answer
To count number of rows in SQL table
SQL
1 vote325 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote298 views3 answers
How to filter repeated same result using sql query
SQL
4 votes278 views1 answer
Postgresql change default value
SQL
1 vote284 views1 answer
How to find median of a column sql
SQL