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?!
LC_JK
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  /

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

9.2 tsas:SAS>
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Thu, 29 Sep 2005 10:14 am

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


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: No registered users and 2 guests