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: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Thu, 8 Jul 2004 16:16:01 +0100
Message-ID: <MPG.1b57758a33229d9a989c8c@news.individual.net>


In article <c2f95fd0.0407080712.5d5b70ee_at_posting.google.com>, jose luis fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?

& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

-- 

jeremy
Received on Thu Jul 08 2004 - 10:16:01 CDT

Original text of this message

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