@echo off 
xxx/yyy@DB.com
set pagesize 0
set heading off
set linesize 1024
set echo off 
set feed off
set tab off
set trimout on
set trims on
spool values.csv

SELECT 'Value1;value2' from dual;

SELECT
PL1.VALUE || ';' ||                     
PL2.VALUE || ';'          
FROM STAT_123 ST
PL_VC    PL1    ,
PL_VC    PL2    
WHERE  ST.CLASS        =    PL1.ID (+)
AND    ST.LEVEL        =    PL2.ID (+);

spool off  
quit  

select STT.VALUE, ST.FACN from ESTAT ST, ESTATTYP STT
where ST.FTYPE = STT.VID
union all
select NG1T.VALUE, NG1.FACN from TRAGWGTYP NG1T, TRAGWG NG1
where NG1.STYPE = NG1T.VID
union all
select PT.VALUE, P.FACN from mas, MASTYP PT
where P.PTYPE = PT.VID

SQL> set colsep ';'
SQL> select ename, job from emp
  2  union all
  3  select dname, loc from dept;

ENAME         ;JOB
--------------;-------------
SMITH         ;CLERK
ALLEN         ;SALESMAN
WARD          ;SALESMAN
JONES         ;MANAGER
MARTIN        ;SALESMAN
BLAKE         ;MANAGER
CLARK         ;MANAGER
SCOTT         ;ANALYST
KING          ;PRESIDENT
TURNER        ;SALESMAN
ADAMS         ;CLERK
JAMES         ;CLERK
FORD          ;ANALYST
MILLER        ;CLERK
ACCOUNTING    ;NEW YORK
RESEARCH      ;DALLAS
SALES         ;CHICAGO
OPERATIONS    ;BOSTON

18 rows selected.

SQL>

set colsep ';'