• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / POWER Function in Oracle SQL – PLSQL

POWER Function in Oracle SQL – PLSQL

November 5, 2012 by techhoneyadmin

The POWER function in Oracle SQL / PLSQL is used to get ‘m’ raised to the power of ‘n’.

Syntax for the POWER function in Oracle SQL / PLSQL is:

SELECT POWER(m,n)
FROM table_name;

  • M is the number to be raised or base
  • N is the number up to which base is to be raised or exponent

Example 1:

SELECT POWER(2,2)
FROM DUAL; 

Will return “4” because 2*2 = 4


Example 2:

SELECT POWER(2,3)
FROM DUAL; 

Will return “8” because 2*2*2 = 8


Example 3:

SELECT POWER(5,3)
FROM DUAL; 

Will return 125 as 5*5*5 = 125


.

Example 4:

SELECT POWER(5,-3)
FROM DUAL; 

Will return 0.008 as 1/(5*5*5) = 0.008


Filed Under: function Tagged With: how to use power function in oracle database query, how to use power function in oracle plsql, how to use power function in oracle sql, power function in oracle plsql, power function in oracle sql, POWERPLSQL, syntax and example of power function in oracle database query, syntax and example of power function in oracle plsql, syntax and example of power function in oracle sql, using power function in oracle database query, using power function in oracle plsql, using power function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in