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 vote294 views1 answer
Acual month sql
SQL
11 votes308 views1 answer
Mysql order by two columns priority
SQL
0 vote333 views1 answer
Pl/pgsql declare variable
SQL
1 vote303 views1 answer
Query for all indexes in table postgres
SQL
1 vote285 views1 answer
Sql select table header
SQL
0 vote324 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote293 views1 answer
How to query all tables mysql at the same time
SQL
0 vote306 views1 answer
Set a value by excuting stored procedure
SQL
2 votes327 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote317 views1 answer
Arithmetic expression in sql
SQL