question about cx_Oracle .thanks

coolmenu menucool at yahoo.com.cn
Fri Jun 25 06:33:07 EDT 2004


David Fraser <davidf at sjsoft.com> wrote in message news:<cbghcs$5m3$1 at ctb-nnrp2.saix.net>...
> coolmenu wrote:
> > Hi 
> >   i hava a db ORACLE 10G,a table valid_card
> > (card_no,varchar2(10),now_balance number (12,2))
> > 
> >  its'some record in table ('7188','42055.66')
> > 
> >  i use cx_Oracle to select now_balance from table
> >  
> >   curobj.execute("select loan_amount from valid_card where
> > card_no='7181930166881974'");
> > [<NumberVar object at 0x013A6920>]
> > 
> >>>>tuple=curobj.fetchone()
> >>>>tuple
> > 
> > (42505.660000000003)
> > 
> > why 42505.66---->42505.6600000000003???
> > thanks
> 
> This is because of the conversion of the float to decimal. Float objects 
> have limited accuracy. I don't think it's much to do with cx_Oracle
> 
> David


Can someone give me a advice? how can i do?
donnt select number from oracle?



More information about the Python-list mailing list