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: SQL Condition

Re: SQL Condition

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 7 Oct 2005 08:03:26 +0200
Message-ID: <43460f82$0$6487$626a14ce@news.free.fr>

"___cliff rayman___" <cliff_at_SPAMMER_GO_HOME_rayman.com> a écrit dans le message de news: _Cl1f.573$k77.130_at_tornado.socal.rr.com...
|
| krallabandi_at_pharmacare.com wrote:
|
| >What is this condition meaning?
| >
| >(TRUNC( MOD( ( SYSDATE- load )*24, 24 ) ) > 0 OR TRUNC( MOD(
| >(SYSDATE- load )*24*60, 60 ) ) > 30)
| >
| >
| greater than a day or greater than 30 hours.
|
| --
| _____cliff_rayman_____________________________________
| Business Consulting and Turnaround Management
| [web] http://www.rayman.com/
| [web] http://all-clear-turnaround-management.com/
| [eml] cliff _at__ rayman.com
| [phn] 888-736-3802 x701
| [fax] 818-743-7404
| ______________________________________________________

Not really: "load+1/24" verifies the condition but not your sentence.

Regards
Michel Cadot Received on Fri Oct 07 2005 - 01:03:26 CDT

Original text of this message

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