Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

best way for to choice number greater than 0.0001

muttleychessJan 11 2012 — edited Jan 12 2012

I must put in where condition all number greater than zero, but the precion must to be in 4th place

I tried in where condition

   trunc(abs(T$QUAN$O),4)>0.0001

Is there some other way ?
There are many columns that must compared (10 )

Tia
using
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

Edited by: muttleychess on Jan 11, 2012 7:01 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2012

Added on Jan 11 2012

#general-database-discussions

6 comments

236 views