Re: ASCII output

In article <33csp0$jg5_at_tamsun.tamu.edu>, m0v5533_at_tamsun.tamu.edu (Mahesh Vallampati) wrote:

> In article <stefan.kleeschulte.2.000DBC70_at_life.lu>,
> Stefan Kleeschulte <stefan.kleeschulte_at_life.lu> wrote:
> >Hi everybody,
> >this might be a simple question for you, but for me as a newcomer to
 Oracle it
> >is not. And please no RTFM advice, I already tried half a meter of the one
> >meter long row of handbooks.
> >How can I produce a comma delimited (or any other special character) output
> >ASCII file from my Oracle table?

Mahesh Vallampati wrote:
> select foo1||,||foo2 from table1 ;
> || is the concatenation parameter. The above statement will produce an output
> like this
> 1,2
> 3,4
> etc.

close, but no cigar, 8o)

you'll need quotes around the string you are concatenating to the column.

 ie. select foo1||','||foo2 from table1;

                  ^^^

the chr() function can also be useful for concatentating control codes, and other non-visual characters.

Jodi.

> U might also want to set head(headings off) off and spool the contents to a
> file.
 

> >I am still using version 6.
> >I'd also be grateful for a hint where to obtain the FAQ's from.
> ftp site: ftp.uni-oldenburg.de
> Path : /pub/unix/oracle .
> >Stefan
 

> -----------------------------------
> Mahesh Vallampati
> M.S. In EE
> Dept.of Electrical Engineering,
> Texas A & M University.
> Ph:(409)845-6189
> \\ In the Beginning there was Codd.....
Received on Wed Aug 24 1994 - 15:08:25 CEST