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

-2 votes208 views1 answer
Remove root password mysql
SQL
0 vote232 views1 answer
Sql value exists in column
SQL
0 vote194 views1 answer
Sqldf change user
SQL
1 vote208 views1 answer
Mysql pretty date format
SQL
23 votes220 views6 answers
Create table sql server
SQL
0 vote204 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote209 views2 answers
Oracle select
SQL
1 vote219 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote250 views1 answer
How to check rollback status in oracle
SQL
0 vote277 views1 answer
Selecting specific day in colum sql
SQL