Home » SQL & PL/SQL » Client Tools » constant record length in spool file
constant record length in spool file [message #198487] Tue, 17 October 2006 06:33 Go to next message
manyal
Messages: 77
Registered: March 2005
Member

Dear Friends,

When i run a query,it returns data and i spool the data in a file,my problem starts now that in a spooled file every record is of constant length in may case it is 80.I want to truncate all the space padded after the last character of each and every lineline.How this can be acheived?

for example

Manish,32,Indore

in the above line though actual data is upto indore but space charaters are padded after indore to make the line size 30 that i don't want, i want to delete all necessary spaces in each and every line.

Thanx in advance.

Manyal





Re: constant record length in spool file [message #198488 is a reply to message #198487] Tue, 17 October 2006 06:37 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
set trimspool on.

This is in the manual and should have been quite easy to find.
It certainly is NOT an expert question; please post in the Newbie forum next time.
Previous Topic: HOW TO USE ISQLPLUS ON STANDALONE PC
Next Topic: Show time values for the date fields in SQL+ Worksheet
Goto Forum:
  


Current Time: Wed Dec 07 16:48:15 CST 2016

Total time taken to generate the page: 0.05874 seconds