Re: download text file
Date: Wed, 01 Sep 1999 07:21:39 GMT
Message-ID: <7u4z3.12503$z35.7751_at_news.rdc1.md.home.com>
[Quoted] 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
J. G. Dutcher +ADw-DutcherJG+AEA-navair.navy.mil+AD4- wrote in message
news:DutcherJG-3108991037460001+AEA-129.131.62.145...
+AD4- I'm looking for a way to down load data from our oracle database (i.e. the
+AD4- opposite of sqlload utilty), especially if I can do tab delimited text
+AD4- files. I've found no way to do it oracle utilities. Can anyone tell me of
+AD4- anything that works?
+AD4-
+AD4- JG Dutcher
+AD4- dutcherjg+AEA-navair.navy.mil
+AD4-
+AD4- TIA
+AD4-
Received on Wed Sep 01 1999 - 09:21:39 CEST