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.org