DROP TABLE IF EXISTS
DECLARE
type l_var_type is table of varchar2(32);
l_table_name l_var_type := l_var_type (
'TABLE01'
,'TABLE02'
,'TABLE03'
);
--
BEGIN
for c in 1..l_table_name.count loop
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || l_table_name(c) || ' cascade constraints';
dbms_output.put_line('TABLE: '||l_table_name(c)|| ' DROPPED');
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -942 THEN
RAISE;
ELSE
dbms_output.put_line('TABLE: '||l_table_name(c)|| ' NOT DROPPED');
END IF;
END;
end loop;
END;
/