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
Received on Sat Nov 10 2001 - 07:14:37 CST
