GENERAR ARCHIVO PLANO ORACLE MEDIANTE SQL

set pagesize 0

set verify off

set feedback off

spool /home/oracle/empleados.txt

SELECT employee_id || '|' || salary || '|' || first_name

FROM hr.employees

/

spool off

set feedback on

set verify on

exit