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
Messages: 69
Registered: July 2006
Location: London

Oracle 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.

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

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

Current Time: Fri Oct 30 11:59:32 CDT 2020