Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SELECT stmt to file with tab delimiters

SELECT stmt to file with tab delimiters

From: Occidental <Occidental_at_comcast.net>
Date: Wed, 5 Dec 2007 15:18:08 -0800 (PST)
Message-ID: <4cfe291c-648b-419a-abf1-c9dc9b473f74@a35g2000prf.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US