How to update ampersend ( & )

Hi Guys,

Any idea how to update & values into the database using PLSQL or Procedure. when I tried it is expecting an input value.

example : updare emp set emp_name = 'abc & def'

Regards
Jag

Try:

set define off
:D

you can also try to use CHR value of &

'this' ||CHR()||'that'