Update varchar2 column containing special character.

I am trying to update a 'You "&" Me' to 'You & Me' i.e.

update table US
set col1 = 'You & Me'
where col1 = 'You "&" Me';

The update works in TOAD but requests a value for Me in SQLPlus.

The update is part of a shell script that calls SQLPlus so I would be grateful if someone could tell me how I can bypass SQLPlus requesting a value.

I would also be more than grateful if someone could explain why I get the desired outcome in TOAD!

Many thanks in advance.
tb3101 Received on Tue Nov 17 2009 - 07:42:59 CST