SQL> set head off
SQL> set feed off
SQL> select 'spool dump_'||deptno||'
  2  select * from emp where deptno='||deptno||' order by ename;'||'
  3  spool off'
  4  from dept
  5  order by deptno
  6  /
spool dump_10
select * from emp where deptno=10 order by ename;
spool off
spool dump_20
select * from emp where deptno=20 order by ename;
spool off
spool dump_30
select * from emp where deptno=30 order by ename;
spool off
spool dump_40
select * from emp where deptno=40 order by ename;
spool off

FOR i IN (SELECT DISTINCT regionid FROM mytable) LOOP
 << prepare you SPOOL script here, the regionid folder would be i.regionid >>
 << like, select 'filename=C:\'||i.regionid||'\IP_claims_'||i.regionid||'_.xls' ....so on>>
END LOOP;

SQL> set serveroutput on;
SQL> 
SQL> DROP table mytable;
 
Table dropped
SQL> CREATE TABLE mytable(regionid NUMBER);
 
Table created
SQL> INSERT INTO mytable VALUES(11213);
 
1 row inserted
SQL> INSERT INTO mytable VALUES(21345);
 
1 row inserted
SQL> INSERT INTO mytable VALUES(6537);
 
1 row inserted
SQL> COMMIT;
 
Commit complete
SQL> DECLARE
  2     VAR_SQL VARCHAR2(4000);
  3  BEGIN
  4     FOR I IN (SELECT REGIONID FROM MYTABLE) LOOP
  5        VAR_SQL := 'export on;' || CHR(10) || 'export set filename="C:\' ||
  6                   I.REGIONID || '\IP_claims_' || I.REGIONID || '_.xls"' ||
  7                   CHR(10) || 'select * from mytable where regionid=' ||
  8                   I.REGIONID || ';';
  9        DBMS_OUTPUT.PUT_LINE(VAR_SQL||CHR(10));
 10     END LOOP;
 11     DBMS_OUTPUT.PUT_LINE(VAR_SQL);
 12  END;
 13  /
 
export on;
export set filename="C:\11213\IP_claims_11213_.xls"
select * from mytable where regionid=11213;

export on;
export set filename="C:\21345\IP_claims_21345_.xls"
select * from mytable where regionid=21345;

export on;
export set filename="C:\6537\IP_claims_6537_.xls"
select * from mytable where regionid=6537;

export on;
export set filename="C:\6537\IP_claims_6537_.xls"
select * from mytable where regionid=6537;
 
PL/SQL procedure successfully completed

SQL> select 'export on;'||'
  2  export set filename="C:\'||regionid||'\IP_claims_'||regionid||'_.xls"
  3  select * from mytable where regionid='||regionid||';'||'
  4  '
  5  from mytable
  6  /
export on;
export set filename="C:\11213\IP_claims_11213_.xls"
select * from mytable where regionid=11213;
export on;
export set filename="C:\21345\IP_claims_21345_.xls"
select * from mytable where regionid=21345;
export on;
export set filename="C:\6537\IP_claims_6537_.xls"
select * from mytable where regionid=6537;