Oracle PL/SQL Tutorial/Numerical Math Functions/EXP

Материал из SQL эксперт
Перейти к: навигация, поиск

EXP(1)

   <source lang="sql">

SQL> select EXP(1) from dual;

   EXP(1)

2.71828183</source>


EXP(2)

   <source lang="sql">

SQL> select EXP(2) from dual;

   EXP(2)

7.3890561</source>
   
  

Using the EXP function

   <source lang="sql">

SQL> SQL> -- create demo table SQL> create table myTable(

 2    id           NUMBER(2),
 3    value        NUMBER(6,2)
 4  )
 5  /

Table created. SQL> SQL> -- prepare data SQL> insert into myTable(ID, value)values (1,9)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (2,2.11)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (3,3.44)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (4,-4.21)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (5,10)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (6,3)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (7,-5.88)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (8,123.45)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (9,98.23)

 2  /

1 row created. SQL> SQL> select * from myTable

 2  /
       ID      VALUE

----------
        1          9
        2       2.11
        3       3.44
        4      -4.21
        5         10
        6          3
        7      -5.88
        8     123.45
        9      98.23

9 rows selected. SQL> SQL> SELECT EXP(value) FROM myTable

 2  /

EXP(VALUE)


8103.08393 8.24824128 31.1869582 .014846368 22026.4658 20.0855369 .002794785 4.1082E+53 4.5788E+42 9 rows selected. SQL> SQL> -- clean the table SQL> drop table myTable

 2  /

Table dropped. SQL></source>