Oracle SQL: Escape Single Quotes

In Oracle databases, to use a single quote character within single quotes, you need to use two single quotes for escaping. For example, if you want to insert a single quote character in a string, you can write it like this:

SELECT 'It''s a beautiful day' FROM dual;

In the example above, two single quotation marks ” represent a single quotation mark character. This allows you to successfully insert a single quotation mark character in a string.