Update varchar2 column containing special character.

From: trub3101 <trub3101_at_sky.com>
Date: Tue, 17 Nov 2009 05:42:59 -0800 (PST)
Message-ID: <00bf0f66-dc6f-45ff-a7e5-b0380c4a281f_at_a31g2000yqn.googlegroups.com>

Hi all,

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

Original text of this message