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 -> Re: how to spool a Tab seperated file

Re: how to spool a Tab seperated file

From: Ed Prochak <edprochak_at_magicinterface.com>
Date: Sat, 10 Nov 2001 03:46:59 GMT
Message-ID: <3BECCE49.31F314E8@magicinterface.com>

Rangeshwara Reddy Kona wrote:
>
> Hi,
> I tried this cuz of my curiosity but I got this output with out tab
>
> 7369chr(8)SMITH chr(8)CLERK chr(8)
> 7902chr(8)17-DEC-80chr(8) 800chr(8) chr(8) 20
> 7499chr(8)ALLEN chr(8)SALESMAN chr(8)
> 7698chr(8)20-FEB-81chr(8) 1600chr(8) 300chr(8) 30
>

Ypu probably put the chr(8) in quotes when it should really be just between the concatenation operators. IOW, instead of

         select id||'chr(8)'||name from my_table;

you should use

         select id||chr(8)||name from my_table;

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com
Received on Fri Nov 09 2001 - 21:46:59 CST

Original text of this message

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