Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sysdate query
Dears.
Sysdate is not a literal, it is a function. The sysdate function is executed for every row, you compare sysdate with a value of a column. So I think the optimizer will interpret TRUNC(sysdate) -0 as a literal.
roy Received on Tue May 09 2006 - 16:44:01 CDT