Home » SQL & PL/SQL » SQL & PL/SQL » Group additions with respect to number systems
Group additions with respect to number systems [message #37026] 
Thu, 10 January 2002 18:37 
C.A.V.B.Srinivas
Messages: 1 Registered: January 2002

Junior Member 


Hi,
The ordinary group additions in oracle is w.r.t
10 (decimal addtion). If I want to add w.r.to the passes parameter ( say 24 or 20,8). How does this addtion be handled in SQL.
Ex..
If There are two quantities say qty=20, qty= 26
then the below query will return me a result of 46 but
my addition W.R.T 24 is 1.22 . To make this addition how can I pass parameter 24 to the built in sum method
or some User defined Group function.




Re: Group additions with respect to number systems [message #37066 is a reply to message #37026] 
Mon, 14 January 2002 17:57 
Prataap
Messages: 4 Registered: January 2002

Junior Member 


Thanks Prataap ,
But one thing, I want the sum of 5 numbers in octal number system. For Example
7,10,20,9,12 are the numbers in decimal number system. Now if I convert it to Octal number system
then I will get 7,12,24,11,14.
Now I want the sum of 7,12,24,11,14 . do we have direct function something like sum(colname,radix) so that I can get the sum directly.




Goto Forum:
Current Time: Sat May 18 15:15:21 CDT 2024
