* SQL Group Function
*
s (num can be a column or ex
pression)
(null values are ign
*
ored, default between distin
ct and all is all)
********************
***************
****************************
****************
AVG([distinct or all] num)
-- average value
COUNT(distinct or all] num)
-- number of values
MAX([distinct or all
] num) -- maximum value
MAX([distinct or all] num)
-- minimum value
STDDEV([distinct or
all] num) -- standard devi
ation
SUM([distinct or all
] num) -- sum of values
VARIANCE([distinct o
r all] num) -- variance of v
alues
********************************
***********************
************************
* Miscellaneaous Functions :
*
********************
***************
****************************
****************
DECODE(expr, srch1,
return1 [,srch2, return2...]
, default]
-- if no search matches t
he expression then the default is returned,
-- otherwise,
the first search that match
es will cause
-- the corres
ponding return value to be r
eturned
DUMP(column_name [,fmt [,start_p
os [, length]]])
-- returns an
column
internal oracle format, used
for getting info about a
-- format options : 8 = oc
tal, 10 = decimel, 16 = hex, 17 = characters
-- return type
codes : 1 = varchar2, 2 = n
umber, 8 = long, 12 = date,
-- 23 = raw,
24 = long raw, 69 = rowid,
96 = char, 106 = mlslabel
GREATEST(expr [,expr2 [, expr3...]]
-- returns the largest val
ue of all expressions
LEAST(expr [,expr2 [, expr3...]]
-- returns the
smallest value of all expre
ssions
NVL(expr1 ,expr2
-- if expr1 is not null, i
t is returned, otherwise expr2 is returned
SQLCODE