SQL Plus Text is wrapping after 80 characters.
320812Aug 9 2004 — edited Aug 9 2004The following is the sql I am using to spool the data into a file. However, I am confused with the output. The text is wrapping after 80 characters and it is adding blank lines after each column in the select. Am I missing some thing here. I appreciate your help.
**********************
set echo off
set feedback off
set termout off
set heading off
set verify off
set pages 0
set long 20000
set linesize
clear columns
spool /opt/consort/hari/hl7_msgs_533.txt
select rtrim(msh_seg) ||
rtrim(pid_seg) ||
rtrim(pv1_seg) ||
rtrim(orc_seg) ||
rtrim(zri_seg) ||
rtrim(obr_seg),
segment_value
from hl7_msgs where message_id = 1;
spool off;
******************************************
Here is the output.
*****************************************
PID|1|007985541|007985541||MOORE,WILLIE,||11-JAN-90|M|||3000 DOLFIELD AVE^^TAL
TIBORE^CP^21215||(510) 766-7000||||BAP||100-10-1000||||||||||||^M
PV1|1 |I|ICU^S412^A||||JAKOBOVITS,JULIAN,MD,MD|,,,||MED|||||||JAKOBOVITS,JULIA
N,MD,MD|I ||||||||||||||||||0 ||||||||09-NOV-97|18-NOV-97||||||||^M
ZRI|1 |LIBRARY GROUP|FILE RM|FILE RM|10-NOV-97||S412|||RAD|^M
OBX|1 |TX|ULT00004^VENOUNI/US^VENOUS IMAGING WITH DOPPLER|||~~RIGHT LOWER EXTR
EMITY VENOUS DOPPLER SONO, 11-10-97, -8965~CLINICAL INDICATION: cellulitis, r/o
DVT~~The right common femoral vein, superficial femoral vein and popliteal veins
were scanned using color flow, duplex and B-mode scanning. The veins were comp
ressible and showed spontaneous flow which augments normally with compression of
the calf.~~IMPRESSION:~~No evidence of deep venous thrombosis in the right femo
ral and right popliteal veins. ~~ ||||||F ||||784|CAMP,LIBA,DD,CD||^M
OBR||9711102125132|35|ULT00004^VENOUNI/US^VENOUS IMAGING WITH DOPPLER|||10-NOV-9
7|10-NOV-97||||||||JAKOBOVITS,JULIAN,MD,MD||||||12-NOV-97|||||||||DOPPLER FLOW S
TUDIES OF R LEG R\O DVT|CAPITAL,SUSAN,CD,|||FORD,VONDA,SKETERS,|||||||||^M
~******************************************
~
~