set heading off
set pagesize 0
set feedback off
set echo off
set termout off
set wrap off

spool /tmp/x01.txt

select EMPNO||'|'|| 
  ENAME ||'|'||  
 JOB ||'|'||
  MGR ||'|'||  
  to_char(HIREDATE,'DD-MON-YYYY')  ||'|'||  
  SAL ||'|'||             
  COMM ||'|'||  
  DEPTNO    
 from emp;

spool off
exit