pl sql escape &

The solution for this is noted below

pl sql escape &

Solution

-- 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

Try other methods by searching on the site. That is if this doesn’t work