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 vote185 views1 answer
How to select a row in sql
SQL
3 votes202 views1 answer
What is having
SQL
0 vote172 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote170 views1 answer
Online sql testing tool
SQL
0 vote197 views1 answer
How to to get time in sql
SQL
5 votes196 views1 answer
Find table from column name in sql
SQL
0 vote213 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote213 views1 answer
Oracle list dblink
SQL
0 vote163 views1 answer
Materialized view redshift
SQL
0 vote178 views2 answers
T sql null or empty string
SQL