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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top