Re: how to spool a Tab seperated file

You're right. 8 is backspace! (that will teach me to leave my ASCII tables backed away.)

Rangeshwara Reddy Kona wrote:
>
> Hi Ed,
> It worked fine.. thanks.. but for tab it seems chr(9)
> Thanks,
> Rangesh
>
> "Ed Prochak" <edprochak_at_magicinterface.com> wrote in message
> news:3BECCE49.31F314E8_at_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

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com