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 vote247 views1 answer
Resullt all update knex mysql
SQL
0 vote226 views1 answer
Reading from right to left from string find first special characters in sql
SQL
22 votes247 views4 answers
Mysql date_format
SQL
1 vote235 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
2 votes229 views2 answers
Sql query to copy data from one column to another
SQL
0 vote216 views1 answer
Ms Sql set us timezone
SQL
0 vote236 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote242 views1 answer
Mysql list bigger table
SQL
0 vote231 views1 answer
Data types mysql vs postgresql
SQL
0 vote233 views1 answer
Find number of entries sql
SQL