Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: