Search This Blog

Sunday, May 1, 2016

Oracle SQL: Error while Inserting text containing single apostrophe or single quote

When we try to insert data containing single apostrophe we end with error saying ' missing comma' as shown below.

To overcome this error, we need to use Q[string].
This will indicate Oracle that we have a string that contains single quote which needs to be inserted.

Now, let's do a select to view the result.

No comments: