POWER(100,0.5): square root : POWER « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. POWER

POWER(100,0.5): square root

  
SQL>
SQL> SELECT
  2  POWER(100, 1)  power_1,
  3  POWER(100,0.5) square_root,
  4  POWER(100,-2)  one_ten_thousandth from dual;

   POWER_1 SQUARE_ROOT ONE_TEN_THOUSANDTH
---------- ----------- ------------------
       100          10              .0001








Related examples in the same category

1.POWER(x, y): Returns the result of x raised to the power y
2.POWER(2, 3)
3.POWER: Returns value raised to some exponential power
4.select power( -5, 3 ) "Using Negatives"
5.select power( 5.2, 2.7 ) "With Reals"
6.POWER(2,3) POWER(-2,3) MOD(8,3) MOD(13,0)