Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Inserting text including &
In Sql*Plus you can issue: set scan off
DBAOracle <dbaoracle_at_aol.com> wrote in message
news:19990714183909.29466.00000297_at_ng-cn1.aol.com...
> I assume you are doing this in sql*plus, where the & represents a
variable.. to
> get around the problem you have to do this:
>
> insert into table
> (col1)
> values
> ('this is a test'||'&'||'this is not');
>
> Note that you seperate the & into it's own
> quotes and cat it to the other
> values.
>
> Robert
Received on Wed Jul 14 1999 - 21:51:38 CDT