Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Insert special characters from SQL-Plus

Insert special characters from SQL-Plus

From: Franck Formis <ffo_at_elca.ch>
Date: Thu, 11 Nov 1999 19:06:44 GMT
Message-ID: <8tEW3.86$U67.71088@news> 





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 Thu Nov 11 1999 - 13:06:44 CST












Original text of this message













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