SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Spooled File...empty lines & spaces problem

272407Jun 12 2007 — edited Jun 13 2007

hi guys

I have a nice problem :-)

I'm using sqlplus to run a query and the result is stored in a spooled file

SET TRIMSPOOL ON is used
to remove empty lines between each result record

the problem that:
I have to append 3 blank spaces after each spooled line as data formate requirement.
but due to enabling TRIMSPOOL those spaces are eliminated :-(((

so please help
how to remove the empty lines between data line meanwhile keepling the required 3 spaces after each data line

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2007

Added on Jun 12 2007

7 comments

2,417 views