Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Getting the 2 first numbers ???
Hello,
I'm using Oracle 8 :
I would like to get the 2 first numbers of the floating part of the result of a division :
12978892/97 = 133803.010309
The numbers i would like to get are "01" (in others words the 2 first numbers after the decimal separator)
I know that i can use plenty of SUBSTR but i think that's not a good answer because in the french Oracle version, the decimal separator is "," and in the US Oracle version it's "."....
So, what can i do to get theses 2 numbers ???
Thanks a lot !
![]() |
![]() |