RE: Insert special characters from SQL-Plus

HI, FRANCK.
THIS IS THE SYNTAX FOR YOUR SITUATION:          insert into emp (EMPNO, ENAME) values (8000,'you'||' & '|| 'me')

LET ME KNOW HOW IT WORKS!
GOOD LUCK!!
MARY -----Original Message-----
From: Franck Formis
Posted At: 11/11/99 2:06 PM
Conversation: Insert special characters from SQL-Plus Subject: Insert special characters from SQL-Plus

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 Fri Nov 12 1999 - 13:25:04 CST