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 value into Oracle table that has a ' in it

Insert value into Oracle table that has a ' in it

From: <gonkowonko_at_gmail.com>
Date: 18 Aug 2005 01:53:08 -0700
Message-ID: <1124355188.857554.262790@f14g2000cwb.googlegroups.com> 





I need help



I want to insert a value into a ORacle table that has a ' in it for
example "Children's"



i do a replace in VB to


courseName = Replace(courseName, "'", "''") and this works for SQL
server but doesnt work for oracle as i get the error message ORA-00917
missing comma error.



I have searched and search but cant find nothing to help so please if
anyone has advice please let me know



Gaz
Received on Thu Aug 18 2005 - 03:53:08 CDT












Original text of this message













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