Special Characters in SQL Queries
Certain characters have a special meaning for Oracle functions. In a SQL Template Designer query, a special character must be escaped in order for the parser to treat it as its intended literal value. The following examples illustrate how to handle commonly used special characters in a query.
See Example of Using a Special Character as a Literal in a SQL Query.
Backslash ( \ ) - Use "\\" instead of "\"
Dollar sign ( $ ) - The $ character must be prefaced (escaped) with a backslash: '.\$'