Home » SQL & PL/SQL » Client Tools » Spool SQL*PLUS Output - No Whitespace
Spool SQL*PLUS Output - No Whitespace [message #231543] Tue, 17 April 2007 07:53 Go to next message
KenJ
Messages: 69
Registered: July 2006
Location: London
Member
Hi,

Oracle 10.2.0.3.0 Enterprise Edition on Linux.

I am spooling a column out of a table into a file. The column is a varchar2(400) and the entries vary from 1 character to 400 characters. Before I run the spool command, I set lines 400 but when I look at the spool file each row is packed out with whitespace to 400 characters.

I would like the 400 characters for the longest rows on one line but would like to eliminate the whitespace oon the shorter lines. Is this possible through SQL*PLUS. I know this can be done through SED etc but I need to use SQL*PLUS only.

Any help greatly appreciated.

Ken.
Re: Spool SQL*PLUS Output - No Whitespace [message #231545 is a reply to message #231543] Tue, 17 April 2007 07:57 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
SET TRIMSPOOL ON


Ross Leishman
Previous Topic: SQL*Loader using TOAD
Next Topic: help required on sqlplus settings
Goto Forum:
  


Current Time: Mon Dec 05 14:47:07 CST 2016

Total time taken to generate the page: 0.10206 seconds