Update varchar2 column containing special character.
Date: Tue, 17 Nov 2009 05:42:59 -0800 (PST)
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