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

vivekam_at_my-deja.com wrote:
>
> 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:

SQL*Plus command 'set define off' disables variables substitution, so you may use & in your data.

> And How do I store a new line character?
As chr(10), e.g. 'man'||chr(10)||'woman'.

Reagards
Maciek Received on Fri Jun 30 2000 - 00:00:00 CEST