Sqlplus opr1d/password@swoprdb1d.nam.nsroot.net:1521/OPRISKD1
set colsep '|'
set echo off
set feedback off
set linesize 1000
set pagesize 9999
set trimspool on
set headsep off
spool output.dat
select <table>.*
from <table>
where <conditions>
spool off