Re: Oracle SQL Help

"Ed Avis" <ed_at_membled.com> wrote in message news:l1ishrjqy6.fsf_at_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>

good observation -- should be the same value, but it would be nice to see that doc'd

i did a quick test (select rownum, sysdate from all_tab_columns) -- query took 5+ seconds, all sysdate values were the same (to the second)

;-{ mcs Received on Sat Feb 28 2004 - 07:47:40 CST