sql developer escape & code example
Example: 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