If you have a insert query and the ata has & in between , the database accepts that as escape character and there is no issues with inserts. for eg
Insert into TABLE_NAME
(COL_ID, COL1 , COL2, COL3)
(5, ‘a random text ‘, ‘A/B with & sign’, 99);
You may find at times that oracle database is not accepting & although it is between quotes.
What you shoudl do ?
Before starting inserts or running sql files, write this
SET ESCAPE ON;
Although it is on by default but once you do this, you should not be facing any issues.