Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SELECT stmt to file with tab delimiters
Suppose you have a SELECT stmt of form:
SELECT Field1, Field2, Field3
FROM Table1
WHERE etc
What would it take to generate a file from the output this stmt, where the fields are tab-delimited? I'm working with an Oracle guy who claims it is impossible. In mysql it is easy
SELECT Field1, Field2, Field3
INTO OUTFILE 'filename'
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
FROM Table1
WHERE etc
Received on Wed Dec 05 2007 - 17:18:08 CST
![]() |
![]() |