Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT stmt to file with tab delimiters
Occidental wrote:
> 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
SELECT col1 || chr(09) || col2
FROM ....;
PS: They are columns ... not fields.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Dec 05 2007 - 17:56:12 CST
![]() |
![]() |