I had occasion on stackoverflow.com to work out an approach I’d long used: WHENEVER SQLERROR EXIT FAIL ROLLBACK set echo on COLUMN programstartdate FORMAT A45 column column_value format a45set serveroutput on<<REINITIALIZE>> BEGIN FOR DOIT IN ( SELECT ‘DROP TABLE ‘ || TABLE_NAME AS CMD FROM USER_TABLES WHERE TABLE_NAME = ‘WFDISPLAYMGMT’) LOOP […]
The views expressed on this blog site are my own and do not necessarily reflect the views of an employer.
The Schema Czar
Experienced thinking on designing, building, supporting, and maintaining software – database software and otherwise.