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
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.
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,' ')
Previous Topic: Time dependent primary key.
Next Topic: How to schedule a job at a certain time?
Goto Forum:

Current Time: Fri Sep 24 16:05:51 CDT 2021