Re: download text file

Mike Rose wrote:

> Hello JG,
>
> You can lookup the details, but you can easily use
> SQL+ACo-Plus/SQL+ACo-Worksheet/TOAD/Access to write data into text files.
>
> For SQL+ACo-Plus
> -- Eliminate unwanted page breaks
> Set PageSize 10000
> -- Spool the output of your query to a file
> Spool YourFile.txt
> -- SQL statement that concatenates a Tab between the columns
> Select Column1 +AHwAfA- chr(09) +AHwAfA- Column2 ...
> From YourTable
> -- Stop spooling
> Spool off

That only works if a person has the "toad" utility. Most developers don't have that utility. However, they probably have sqlplus. It really makes little sense to tell someone to use a little-know, obscure third-party utility when sqlplus provides what they need. Received on Wed Sep 01 1999 - 14:24:01 CEST