Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Plus Text is wrapping after 80 characters.

320812Aug 9 2004 — edited Aug 9 2004
The 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
~******************************************

~
~
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2004
Added on Aug 9 2004
5 comments
1,848 views