Re: Tuning Update query
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Mon, 3 May 2021 19:55:47 +0100
Message-ID: <CAGtsp8mvf1vqEGkAt3XaF2YyS20+4ojtaKdVk9e+SVvvY-Uq=g_at_mail.gmail.com>
Date: Mon, 3 May 2021 19:55:47 +0100
Message-ID: <CAGtsp8mvf1vqEGkAt3XaF2YyS20+4ojtaKdVk9e+SVvvY-Uq=g_at_mail.gmail.com>
William,
Thanks for running the test.
I tweeted the change, and Andrew Sayer has pointed out that the change
appeared in 19.10 with a fix control.
(Unfortunately LiveSQL.com is still running on 19.8, and I'm still down at
19.3)
Regards
Jonathan Lewis
On Mon, 3 May 2021 at 19:25, William Robertson <william_at_williamrobertson.net> wrote:
> That does indeed work in 21c, and correctly updates the running total from
> an analytic sum(). Very cool.
>
> Connected to Oracle Database 21c Enterprise Edition Release 21.0.0.0.0
>
> SQL> update
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 03 2021 - 20:55:47 CEST