Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

2,66666

12.05      How to use ceil( ) function

Syntax: select ceil(l,2) "ceil" from dual ; RESULT:

cell

-----

2

12.06      How to use floor( )

function

Syntax: select  floor(l,2) "floor" from dual ; RESULT:

floor

----- l

12.07      How to use power( )

function

Syntax: select  power(8,3) "power" from dual ; RESULT:

power