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

SQL> SELECT 'Frank''s Oracle site' AS text FROM DUAL; TEXT ... These characters can be escaped in SQL. ... Escape ampersand (&) characters in SQL* Plus.

www.google.com.tw