Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sysdate while updating

sysdate while updating

From: Igor Sereda <sereda_at_spb.runnet.ru>
Date: Thu, 07 May 1998 14:39:17 -0400
Message-ID: <3551FFD5.B0949920@spb.runnet.ru> 





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
Received on Thu May 07 1998 - 13:39:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US