RE: Qustion on Select statement
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'RStorey@xxxxxxxxxxxxxxxxxx'" <RStorey@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 2 Dec 2010 14:45:28 -0600
There's a COLSEP setting that might work
SQL> set COLSEP ''
Seems to work for me.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Storey, Robert (DCSO)
Sent: Thursday, December 02, 2010 2:37 PM
To: oracle-l-freelists
Subject: Qustion on Select statement
I've written a query to produce a flat file through the use of the Spool
command. Everything works perfectly except for one small detail.
By default, the output of a Select statement has a default colsep of a blank.
So, my formatting is way off due to a single blank being inserted between each
of the returned values in my line.
Select rpad(value1,15), rpad(value2,12), rpad(value3,8)
From <table>
Where value1 > 100.
So, what I get is (using a $ for blanks and a * for the field padding).
Value1*********$value2******$value3**
Is there a way or a setting that would disable the separation between values
returned in a Select?
Thanks, Bob
Other related posts:
