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 shops
set shop_name='Lorel&&Hardy'
where code = 69;
Do not try those tricks at home.