Oracle ×î³£Óù¦Äܺ¯Êý¾­µä»ã×Ü

¡¡¡¡* 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
¡¡¡¡¡¡¡¡¡¡