Re: Insert special characters from SQL-Plus

HI!

One Solution: put an "set define off" in front of the statement

Regards

Thorsten

Franck Formis schrieb:
>
> Hi,
>
> Is there anybody knowing how to insert a string like "you & me" in a
> table from SQL-PLus ?
> Doing it straight forward give you back the following error :
>
> SQL> insert into emp (EMPNO, ENAME) values (8000,you & me);
> Enter value for me:
>
> Thanks,
>
> Franck Formis
Received on Sat Nov 13 1999 - 02:18:08 CST