Home » Other » 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.

Report message to a moderator

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: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
 
SET TRIMSPOOL ON

Ross Leishman

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 13:07:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.