Escape special characters in Oracle scripts

In Oracle, we all know that the two single quotes are character-type, But how should we write single quotes in a script. Of course, you can use '''' (four single quotes) to assemble a single quotation mark.

In plsql, how do you update text containing carriage return to the database in the form of update?

At this time, escape is required:

There are two types of conversion. One is to convert the string to the asc code, and the other is to convert the asc code into a string.

Example:

Select chr (92) from dual;

Select ascii ('\ n') from dual;

What should I do if I need to find the ascii code corresponding to single quotes?

Select ascii (''') from dual;

Over, close the case!