There are several methods to put the quote into the string.
The first (and very traditional) one: use 2 quotes.
SELECT ‘This ” is quote’ FROM dual;
If there are more than one quote, it’s difficult to read and write such strings
The second: use chr(39)
SELECT ‘This ‘ || CHR(39) || ‘ is quote’ […]