Mega Code Archive
Drop only if table exists
SQL> BEGIN
2
3 FOR i IN (SELECT table_name FROM user_tables WHERE table_name = 'SHARED_ALL') LOOP
4 EXECUTE IMMEDIATE 'DROP TABLE shared_all';
5 END LOOP;
6
7 END;
8 /
PL/SQL procedure successfully completed.
SQL>