Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Special "&" Character

Re: Special "&" Character

From: Steve Blomeley <steveblomeley_at_yahoo.co.uk>
Date: 2000/06/24
Message-ID: <3954040D.C5F7FABA@yahoo.co.uk>#1/1

Ethan Post wrote:
>
> insert into test values('This &q');
>
> When I insert this value the @q is prompting me for a value as opposed
> to actually inserting the value "&q". What do I need to do to get it
> to insert "&q"?
>
> -Ethan
> http://www.gnumetrics.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Try this:

SQL> SET DEFINE OFF
SQL> insert into test values('This &q'); Received on Sat Jun 24 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US