Function to do calculation of substation in sql

[LC_JK]

Galera, the Oracle has some function that make power calculation for me?!

for example ... I want to know the result of the number 10 raised to 2, 7.
How do I do that?!

If it was 10 to the power of 2, then I would do 10 x 10 ... but as decimal number exists, then it complicates my life!!

Can someone help?!

[dr_gori]

Yes, use POWER.

Code: Select all

9.2 tsas:SAS> select power(10, 2.7 ) from dual
  2  /

POWER(10,2.7)
-------------
   501.187234

9.2 tsas:SAS>


[LC_JK]

Thank you....