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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle SQL Help

Re: Oracle SQL Help

From: Ed Avis <ed_at_membled.com>
Date: 28 Feb 2004 13:04:17 +0000
Message-ID: <l1ishrjqy6.fsf@budvar.future-i.net> 





"Mark C. Stock" <mcstockX_at_Xenquery .com> writes:



>AND CREATED_DTM >= (sysdate - (1/24))




If the query takes a long time to run, will it use the value of
sysdate that was in effect when it first started to execute, or will
sysdate be reevaluated for each row?


-- 
Ed Avis <ed_at_membled.com>


Received on Sat Feb 28 2004 - 07:04:17 CST












Original text of this message













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