Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help With a Decode
1- You don't need to select from dual to use sysdate...
2- You seem to be going at the result in a very round about way ...
How about something like
Select nvl(max(created),sysdate-3) from audit;
Received on Mon Jun 27 2005 - 18:28:38 CDT