Insert String values with apostrophes ...
How can I insert String values containing apostrophes into a database when using embedded SQL in Java?
Example:
INSERT INTO EMPLOYEE (NAME) VALUES (\'" + getEmployeeName + "\')
where getEmployeeName contains the String value "O'Conell".
At the moment Oracle handles the "O" part only and complains about a missing comma for the 2nd part.
Adding INSTR or SUBSTR does not solve the problem because those require multiple arguments.