Database, SQL and PL/SQL

How to escape special symbols in Oracle SQL, PL/SQL (i.e. “&”)?

For escaping “&” or other special symbols in SQL or PL/SQL use function utl_i18n.escape_reference(string_needed_to_escape):

select UTL_I18N.ESCAPE_REFERENCE(‘Here is my special symbol: ‘||chr(38)) from dual

Example returns “Here is my special symbol: &