I'm trying to insert the following text in my table.
Group(Equity Management/Corp, D\&IB Exec Accountability,P\&L Management, Customer Experience)
The problem is that oracle is asking for a parameter input because of & sign. I tried using escape to avoid that special character, but I'm having the same issue.
escape option 1:
INSERT into rpt_lob
values (null, null, '{Group(Equity Management/Corp, D&IB Exec Account,P&L Management, Customer Experience)}')
escape option 2:
INSERT into rpt_lob
values (null, null, 'Group(Equity Management/Corp, D\&IB Exec Account,P\&L Management, Customer Experience)')
Please guide me as to how I can enter this text and escape the special characters.
Thanks!