Example of Using a Special Character as a Literal in a SQL Query
Outside of the Portal's SQL Template Designer environment, certain characters and symbols have a special meaning to Oracle functions when querying an Oracle database directly. For example, the $ can be used as a parameter in an Oracle function. In the context of the SQL Template Designer, this $ character must be prefaced (escaped) with a backslash, as shown in the following example.
select REGEXP_REPLACE(APT_V_TSM_JOB.DOMAIN_NAME|| '.' || APT_V_TSM_JOB.SCHEDULE_NAME,'.\$','') GROUP_NAME from APT_V_TSM_JOB