OraFAQ Forum: Training & Certification » flat file output with trailing blanks

Home » Other » Training & Certification » flat file output with trailing blanks

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

flat file output with trailing blanks [message #288824]

Tue, 18 December 2007 17:32

ottsompol
Messages: 9
Registered: December 2007

Junior Member

Hi,
I am exporting to a fixed-width data file. The format calls for the last 5 positions to be blanks. Looks like SQL drops the trailing empty string. please help.

current result:
1234456
1233455
1234554

desire result:

1234456(5spaces)
1233455(5spaces)
1234554(5spaces)

Report message to a moderator

Re: flat file output with trailing blanks [message #288844 is a reply to message #288824]

Tue, 18 December 2007 22:14

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

"Exporting?" Using an import/export utility? Or just spooling? If you are just spooling to a flat file from SQL*Plus, then:

SET TRIM OFF
SET TRIMSPOOL OFF

as explained in the documentation excerpts below.

SET TRIM[OUT] {ON | OFF}

Determines whether SQL*Plus puts trailing blanks at the end of each displayed line. ON removes blanks at the end of each line, improving performance especially when you access SQL*Plus from a slow communications device. OFF enables SQL*Plus to display trailing blanks. TRIMOUT ON does not affect spooled output.

SET TRIMS[POOL] {ON | OFF}

Determines whether SQL*Plus puts trailing blanks at the end of each spooled line. ON removes blanks at the end of each line. OFF enables SQL*Plus to include trailing blanks. TRIMSPOOL ON does not affect terminal output.

Report message to a moderator

Re: flat file output with trailing blanks [message #289438 is a reply to message #288844]

Fri, 21 December 2007 12:30

ottsompol
Messages: 9
Registered: December 2007

Junior Member

Thank you Barbara for directing me to the solution. I set the linesize to the width of the flat file specification and set trimspool on and it came out exactly the way I need it.

Report message to a moderator

Previous Topic:	creating new database
Next Topic:	Fixed Assets (merged 2 threads)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 13:53:35 CST 2024