OraFAQ Forum: Server Administration » Spooling generates more records...why

Home » RDBMS Server » Server Administration » Spooling generates more records...why

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

Spooling generates more records...why [message #373084]

Mon, 26 March 2001 16:56

Dave
Messages: 92
Registered: August 1999

Member

Hi,

I am spooling a table to a flat file. One of the columns is a long field (i.e. varchar2(20000)).

The problem is that if there are any newline characters in the field, spooling generates a new record in the flat file. Example output is below.

Instaed of generating:

"1000034 | 01/01/01 | This is a good time of day"

This is what is actually generated:

"1000034 | 01/01/01 | This is a good
| | of day"

The "|" is the record seperator.
Is there any way of making the spool command ignore newline characters?

Any help would be appriciated.

Thanks

Dave

Report message to a moderator

Previous Topic:	How to set Image path for the column ?
Next Topic:	Create a table with all the days between two days

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 06:00:02 CST 2024