Every one who write queries in Oracle knows that for inserting comma (') into a varchar field you need to double it, which will look like this:
insert into shops(shop_name, description)values ('Adam''s shop', 'selling bugs for free');
But I've found out this one too (and also found out that there are many of you that don't know this trick)try to write the query with this special character - & (And)Oracle will think that this one is a parameter asking you to insert value.so I said why not double it too.
update shopsset shop_name='Lorel&&Hardy'where code = 69;
Do not try those tricks at home.
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.