Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Insert value into Oracle table that has a ' in it
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