Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Fri, 2 Sep 2016 11:13:29 +1000
Message-ID: <CAFeFPA-1J4dvoWD-ZCSr86nnDe5Hv8Y=sN31B2tJnJos3Thd0Q_at_mail.gmail.com>

update customers set ein = replace(ein,'''');

worked for me... Going to state the obvious but did you issue a commit?

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

On Fri, Sep 2, 2016 at 10:40 AM, Rob Lockard <rob_at_oraclewizard.com> wrote:

> This should be easy, maybe i've been working it for too long, or don't
> know.
>
> Anyway, I have a column that wound up getting populated with a leading '
> (single quote)
>
> update customers set ein = replace(ein,''''); and update customers set ein
> = replace(ein,chr(39)); does not work. Well, the message says updated but
> when I query the table, it's still there. There is something simple that
> I'm missing and for the life of me, I can't figure it out.
>
> The definition of insanity is doing the same thing over and over expecting
> different results. By that definition; I've been insane for the past two
> hours.
> -Rob
>
> --
> ================================
> "Rules are for the obedience of fools and the guidance of wise men"
> -Douglas Bader
> Robert P. Lockard, Oracle ACE
> www.oraclewizard.com
> (c) 571.276.4790
> Twitter: _at_YourNavionPilot
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 02 2016 - 03:13:29 CEST