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 votes185 views5 answers
Sqlite install python
SQL
0 vote204 views2 answers
Sql having multiple conditions
SQL
0 vote171 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote172 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote141 views1 answer
Alter user mysql native password
SQL
0 vote172 views1 answer
Mysql remove tabs from string
SQL
0 vote217 views1 answer
Pagination with row_number
SQL
0 vote197 views1 answer
Postgresql delete limit
SQL
1 vote203 views1 answer
Mysql select all and rename one
SQL
0 vote216 views1 answer
How to enable mysql 5.7 root user password on linux
SQL