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