
April 24th, 2002, 04:25 PM
|
|
Contributing User
|
|
Join Date: May 2001
Location: Tulsa, OK
Posts: 90
Time spent in forums: 10 h 26 m 56 sec
Reputation Power: 13
|
|
Oracle SELECT INTO OUTFILE problem
Hello, I am using Oracle and trying to output the returned query data to a TAB Delimited file. I tried using
"SELECT columns FROM tables INTO OUTFILE 'dir/filename.txt' FIELDS TERMINATED BY '\t' WHERE conditions"
But Oracle just gives the Error:
"Warning: OCIStmtExecute: ORA-00905: missing keyword"
Am I doing this incorrectly or does Oracle just not support it, or is there another way to send the data to a file? I am currently sending it to an outfile by looping through each row, storing it in a variable, and then writing it to a file, but it takes quite a while, since the query returns a LOT of data. Thanks in advance.
-Chris C.
|