Re: sysdate while updating

From: BobH <b-horton_at_worldnet.att.net>
Date: Sun, 10 May 1998 23:01:03 -0400
Message-ID: <6j5pn0$pl5@bgtnsc02.worldnet.att.net>

Igor Sereda wrote:
>
> Hello,
>
> Does the Oracle lock the value of the function while performing
> long queries as such:
>
> UPDATE TABLE SET COLUMN = SYSDATE;
>
> I ran a test and learned that the value of sysdate is being calculated
> once. Is there a way to force Oracle to recalculate functions
> each time (for each row, heh? :)
>
> Regards,
> Igor
>
> --
> Igor Sereda,
> ITC, Russia

It looks like from your SQL that is gets SYSDATE one time and applies to all rows. I am not trying to be facitious, but why would you want to get a new SYSDATE for each row? Isn't the clock function a cpu hog?

Best. Received on Sun May 10 1998 - 22:01:03 CDT