Oracle Built In Functions:EXP function

Exp Function returns the exponent value of the given input or EXP Returns e raised to the nth Power,where e=2.71828183.

Syntax
———
EXP(input)

NOTE: Input must be a numeric value.

Example

SELECT EXP(4) “exp” FROM DUAL;

Output>>

exp

——————

54.59815

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .

Identification

Article search

Sections

Oracle Administration (6.13.2010)
- Introduction to DataBase Administration (8.14.2010)
- Types of Oracle Database users (8.14.2010)
Oracle Backup and Recovery (6.13.2010)
- Oracle Backup:Basic concepts (8.15.2010)
- Oracle Recovery:Basic Concepts (8.15.2010)
Oracle PL/SQL (6.13.2010)
- ASCII Function in PL/SQL (6.19.2010)
- Oracle PL/SQL:Built In Exceptions (7.15.2010)
- PL/SQL:CASE Statement (7.15.2010)
- Character Functions in PL/SQL (6.19.2010)
- Comments in PL/SQL (6.18.2010)
- Conditional Control Statments (7.15.2010)
- Cursor FOR Loop (7.26.2010)
- Oracle PL/SQL:Data Types (7.15.2010)
- Oracle PL/SQL:Constants (7.15.2010)
- Oracle PL/SQL :Declaring Variables (7.15.2010)
- Delimiters (6.17.2010)
- EXIT Statement in PL/SQL (7.22.2010)
- EXIT-WHEN statement in PL SQL (7.22.2010)
- FOR Loop in Oracle PL SQL (7.26.2010)
- Fundementals of PL/SQL (6.15.2010)
  - Declarations (6.17.2010)
- PL/SQL:GOTO Statement (7.18.2010)
- Identifiers (6.16.2010)
- Identifiers(contd..) (6.16.2010)
- Oracle PL/SQL:IF-THEN-ELSE Statment (7.15.2010)
- INSTRC Function in PL/SQL (6.19.2010)
- Introduction to PL/SQL (6.13.2010)
- Lexical Units (6.15.2010)
- Loop statement In PL SQL (7.22.2010)
- Loops in Oracle PL SQL (7.20.2010)
- NLS_LOWER Function in PL/SQL (6.20.2010)
- Oracle Built In Functions:ACOS function (7.10.2010)
- Oracle Built In Functions:ADD_MONTHS Function (7.10.2010)
- Oracle Built In Functions:ATAN function (7.10.2010)
- Oracle Built in Functions:ATAN2 function (7.10.2010)
- Oracle Built in Functions:AVG function (7.10.2010)
- Oracle Built In Functions:CEIL function (7.10.2010)
- Oracle Built In Functions:EXP function (7.10.2010)
- Oracle Built In Functions:FLOOR function (7.10.2010)
- Oracle Built In Functions:LN function (7.10.2010)
- Oracle Built In Functions:MOD function (7.10.2010)
- Oracle Built In Functions:Numeric Functions (7.10.2010)
- Oracle Built In Functions:SIGN Function (7.10.2010)
- Oracle Built In Functions:SIN function (7.10.2010)
- Oracle Built In Functions:SINH function (7.10.2010)
- Oracle Built In Functions:SQRT function (7.10.2010)
- Oracle Built In Functions:TAN function (7.10.2010)
- Oracle Built in Functions:LOG function (7.10.2010)
- PL/SQL Built-in Functions (6.19.2010)
- PL/SQL Character Set (6.15.2010)
- RETURN Statement in PL SQL (7.22.2010)
- Sequential Control Statements (7.18.2010)
- Oracle PL/SQL:Stored Functions (7.15.2010)
- Oracle PL/SQL:Stored Procedures (7.15.2010)
- Oracle Pl/SQL Stored Procedures:Procedure Parameters (7.15.2010)
- Stored Procedures:Advanced Concepts (7.15.2010)
- WHILE Loop in Oracle PL SQL (7.27.2010)
Oracle Database Tuning (6.13.2010)
- SQL Tuning Tips-Identify Bad SQL Statements (8.12.2010)
Partners (8.4.2010)
Oracle SQL * Plus (6.13.2010)
- Introduction to SQL (7.12.2010)
- Introduction to SQL* Plus (8.2.2010)
- SQL Select Statement (8.8.2010)
- Script Files in SQL * Plus (8.3.2010)
- SQL * Plus Editing Commands (8.2.2010)
About Us (6.16.2010)

Last articles

Partitioning in oracle (3.26.2011)
Using SQL statements in C (2.15.2011)
UTL_FILE_DIR in Oracle (1.28.2011)
Use DECODE for IF/ELSE Selection (1.27.2011)
DBMS_ALERT Package (1.19.2011)
Oracle 11g:Automatic Storage Management (1.1.2011)
Using SQL Trace in oracle (12.29.2010)
Exception Handling in Oracle PL/SQL (12.21.2010)
Relational Database Management System(RDBMS) (12.21.2010)
Pseudocolumns in SQL (12.18.2010)

Monthly archives

Favourite sites

Subscribe to this site

Stay current with Techno Oracle on these personalized pages: