Re: how to insert '&' , newline char .....

<vivekam_at_my-deja.com> wrote in message news:8ji1ds$259$1_at_nnrp1.deja.com...
> Hello all!
>
> How can I store a string 'man&woman' in a varchar2 column.
> I mean if I enter the insert statement in sqlplus it is asking the
> value for woman:
>
> And How do I store a new line character?
>
> Thanx in advance
>
> vivekam
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

"set scan off" will turn off Oracle's interpretation of the ampersand as a variable prompt.

Use chr(10) for a carriage return.

-Matt Received on Fri Jun 30 2000 - 00:00:00 CEST