Re: Problem updating latest value (date) column for a given key

From: Peter L <abc_at_123.com>
Date: Fri, 09 Aug 2002 22:41:13 GMT
Message-ID: <g8h8lu4emavtl1ur5hgms87kp32n3dg0c5@4ax.com>

On Thu, 1 Aug 2002 20:25:37 +0100, "Dave Siddons" <davesiddons_at_lineone.net> wrote:

>
>I've been tryng to come with a way in PL/SQL that would utilise one full
>table scan (as a cursor and do the updates through that.)
>
>Possibly identify the correct row (highest end_date for each id), store the
>rowid and then apply the change via that. Worried about rollback
>requirements though.
>
>Keep on thinkin ...........
>

You can use some of the new analytical functions to help with this sort of thing. I had a look at them a while back and they were very quick. I can't remember all the details but I'm fairly sure it was under 'windowing' in the docs. Received on Fri Aug 09 2002 - 17:41:13 CDT