Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is select sum() from number Oracle column rounded ?
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Why is select sum() from number Oracle column rounded ?
Divers
Thread ID:
00297819
Message ID:
00297819
Vues:
71
Hi,
I have a table on Oracle with column number(13,2).
example:
_sqlexec("create table bla (bla number(13,2))")
_sqlexec("insert into bla values (3.14)")
after
_sqlexec("select * from bla")
I've got number 3.14
but after
_sqlexec("select sum(bla) from bla")
I've got number 3
and
_sqlexec("select to_char(sum(bla)) from bla")
return
char 3.14

Why sum() function rounded values ?
Pavel Poul
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform