Quoth the Raven

There is a handy little function that was introduced in 10g. It helps with the pain of escaping single ticks in string literals:

This comes in handy when doing dynamic SQL where you want to execute complicated queries in an execute immediate call.

For further documentation see the Oracle documentation.

Leave a Reply

Your email address will not be published. Required fields are marked *