Q
Problem solve Get help with specific problems with your technologies, process and projects.

Spooling result set into file without the newline character

I am spooling the result set of an SQL query into a file using Oracle 8 SQL*Plus. It prints each record on a separate line, i.e. it inserts a newline character after each record. Is there a way to get all the records written into the file without the newline character?

If you want to simply spool the results of a query, you can't avoid the newline. In order to get a single, long character string of results, you'd have to write a PL/SQL routine to do so. That routine could use one of several ways but basically you'd have to use a cursor to loop through the result set and create a concatenated string of values.

For More Information


Dig Deeper on Oracle database design and architecture

Join the conversation

2 comments

Send me notifications when other members comment.

Please create a username to comment.

I am using spooling but my out is wrap around instead of separate line.

I tried using printf "n" >> file.dat in my shell script.

total transaction count: 179 userid count: 11 ALOC count: 74 ASV count: 90 TWN asset data - income count: 13 TWN asset data - employment count: 74 property info count: 1 ID check failure count: 6


Cancel

This is my email output. I want it to be on separate lines like below.

total transaction count: 179

userid count: 11

ALOC count: 74

ASV count: 90

TWN asset data – income count: 13

TWN asset data – employment count: 74

property info count: 1

 ID check failure count: 6


Cancel

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close