Oracle Drop多表

DECLARE
  I INTEGER;
BEGIN
  FOR TODROP IN (SELECT TABLE_NAME
                   FROM USER_TABLES
                  WHERE TABLE_NAME LIKE '%_HD') LOOP
    EXECUTE IMMEDIATE 'drop table ' || TODROP.TABLE_NAME || '';
  END LOOP;
END;