Q

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


This was first published in April 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close