Home » SQL & PL/SQL » SQL & PL/SQL » SQLPlus trimming spaces in spool file
SQLPlus trimming spaces in spool file [message #37566] Thu, 14 February 2002 07:06 Go to next message
Theo
Messages: 5
Registered: July 2000
Junior Member
I have a SQLPlus script which is selecting a record from the database which has a length of 300 Character. The script is spooling the output to a text file. The problem that I have is that the line is being truncated because the last 20 to 30 character are blank but I require the output file to be the full 300. Is there a way to spool the entire record incluing spaces to the spool file. I have tried setting trimspool to off.

Report message to a moderator

Re: SQLPlus trimming spaces in spool file [message #37576 is a reply to message #37566] Thu, 14 February 2002 12:08 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use rpad(col1,300,' ')

Report message to a moderator

Previous Topic: Time dependent primary key.
Next Topic: How to schedule a job at a certain time?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 21:12:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.