Re: Inserting text including &

From: Richard Gowan <roxl_at_ozemail.com.au>
Date: Mon, 02 Aug 1999 00:04:04 +1000
Message-ID: <etYo3.2448$_Q2.22051@ozemail.com.au>

It's also possible to tell SQL*Plus to ignore the &. I can't remember the option, but it'll be under the online help for keyword SET.

Regards,

Richard Gowan

DBAOracle wrote:
>
> 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 Sun Aug 01 1999 - 09:04:04 CDT