Function to do calculation of substation in sql

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Wed, 28 Sep 2005 4:10 pm

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?!
Location: São Paulo

Poston Thu, 29 Sep 2005 8:56 am

Yes, use POWER.

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


9.2 tsas:SAS>
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Poston Thu, 29 Sep 2005 10:14 am

Thank you....
Location: São Paulo

  • See also
    Last Post

Return to SQL

Who is online

Users browsing this forum: No registered users and 1 guest