hali

declare        a varchar2(500);        tname varchar2(50);begin        a:='select table_name from user_tables where table_name like ''abc%''';        execute immediate a into tname;        dbms_output.put_line('Table name is: '||tname);        execute immediate 'drop table "'||tname||'"';        dbms_output.put_line(a);end;/# Change ''abc%'' to a valid string for your table