pl sql escape &
-- syntax (This is specifically for PLSQL) ||CHR(38)|| -- example (You want: 'This symbol, &, works!') 'This symbol, '||CHR(38)||', works!' -- Note: You could also use the "SET DEFINE ~;" code. Please see the -- reference/source (URL) for more details