Re: sql*plus INSERT problem

Michele Garb <garbm_at_itersd1.iterus.org> wrote:
>As you've already been told & is a reserved character and in
>sqlplus it will alway think that you are using the & to represent
>a variable. I do however know of one way to get around this. Put
>the & character between single quotes and then concatinate it to
>the rest of your string. So for instanse if you are trying to set
>ENAME in the EMP table to "Jan & Tom" the syntax would be:
>
>insert into EMP (ENAME) values ('Jan '||'&'||' Tom');
>--
>Michele Garb garbm_at_iterus.org
>SAIC, ITER San Diego Joint Work Site
>11025 North Torrey Pines Road, La Jolla, CA 92037
>

Use SQL*Plus command

SET DEFINE OFF The SQL*Plus session will not scan for variables then. You can also redefine the character as another if you use "&" often in data.

DL Kray Received on Mon Nov 13 1995 - 00:00:00 CET