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: How do to insert '&' character from sqlplus ?

Re: How do to insert '&' character from sqlplus ?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 08 Jul 2004 23:29:38 GMT
Message-ID: <pan.2004.07.08.23.29.37.722061@sbcglobal.net>


On Thu, 08 Jul 2004 08:12:26 -0700, jose luis fernandez diaz wrote:

> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

set define ";"
set sqlterminator "&"

-- 
Well-behaved women seldom make history
Received on Thu Jul 08 2004 - 18:29:38 CDT

Original text of this message

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