How does one escape special characters when writing SQL queries ...

These characters can be escaped in SQL. ... combinations of single and double quotes (and/or all other special characters), no matter where they are in a string, ...

www.orafaq.com