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;
