Re: how to spool a Tab seperated file

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