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: sivkrish <sivkrish_at_cisco.com>
Date: Thu, 08 Jul 2004 17:01:21 -0700
Message-ID: <40EDE051.6000002@cisco.com>


You can use set escape on and use backslash.

SET ESCAPE ON; '\&'

Mladen Gogala wrote:
> 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 "&"
>
Received on Thu Jul 08 2004 - 19:01:21 CDT

Original text of this message

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