Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: quick sql question
A horizontal tab is chr(9). Chr(8) is a backspace.
Andy Johnson
Sybrand Bakker wrote:
>
> select 'new'||chr(8)||'bie?'
> from dual
> /
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <jimbo1155_at_my-deja.com> wrote in message news:94a392$tvv$1_at_nnrp1.deja.com...
> > Can someone show me how to concatenate a tab character to a string in a
> > sql statement?
> > Can't find it in the doc that I have.
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
Received on Sat Jan 20 2001 - 01:23:22 CST