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 HOW TO RETRIEVE NUMERIC DATA

Apart from numeric static value, oracle classified some functions under three categories like single value function, group of values, lists of values, All parameters options involved in string function like option, pair of parentheses,

Single  Value Function : Using this function one can select one column of the one row out of whole table, In another way, after considering many values and generate a single value,

 

12.01    How to use numeric operator ( + ) addition

 

SYNTAX: select (8+3) "add" from dual ; RESULT:

add

 

----

 

11

 

Find Your Next Great Read

Describe what you're looking for in as much detail as you'd like.
Our AI reads your request and finds the best matching books for you.

Showing results for ""

Popular searches:

Romance Mystery & Thriller Self-Help Sci-Fi Business