Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do to insert '&' character from sqlplus ?
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!
-- jeremyReceived on Thu Jul 08 2004 - 10:16:01 CDT