begin
for x in (select object_name from user_objects where object_name like 'CDD_%') loop
execute immediate 'delete from '||x.object_name;
end loop;
end;
begin
for x in (select object_name from user_objects where object_name like 'CDD_%') loop
execute immediate 'delete from '||x.object_name;
end loop;
end;