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 -> Inserting "&" in SQL*Plus

Inserting "&" in SQL*Plus

From: Matt Kelly <mkelly_at_shell.clark.net>
Date: Thu, 12 Aug 1999 21:26:38 GMT
Message-ID: <i_Gs3.314$BI1.16839@iad-read.news.verio.net> 





Question:



INSERT INTO test_table (company_name) VALUES ('a & b industries');



What can I use to ESCAPE the "&" in the example above?  



SQL*Plus keeps prompting me for the value of "b", but I only 
want to store the text string "a & b industries".



Please email me if you know the answer!



Thanks,



-- 


Matthew Kelly


mkelly_at_clark.net  
Received on Thu Aug 12 1999 - 16:26:38 CDT












Original text of this message













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