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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

12.02      How to use numeric operator ( - ) subtraction

 

SYNTAX: select  (8-3) "subtract" from dual ; RESULT:

subtract

 

5

 

 

12.03      How to use numeric operator ( * ) multiplication

 

SYNTAX: select  (8*3) "multiply" from dual ;

 

 

 

RESULT:

 

multiply

 

----------

 

24

 

 

12.04      How to use numeric operator ( I ) division

 

SYNTAX: select  (813) "divide" from dual ; RESULT:

divide

 

-----------