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