Re: SELECT stmt to file with tab delimiters

On Dec 5, 3:56 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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.

But what if the data has embedded tabs?

jg

--
@home.com is bogus.
Bad DBA!  Bad, Bad, Bad DBA!  http://www.channelregister.co.uk/2007/12/04/admin_steals_consumer_records/