sangeeta

• Jun 1st, 2005

 

max,min,sum,avg,count

Navin

• Mar 14th, 2006

 

There are six basic types of built-in functions

 

Character functions analyze and modify the contents of CHAR and VARCHAR2 string variables.

Numeric functions are a full range of operations that manipulate numbers, including trigonometric, logarithmic, and exponential functions.

Date functions are utilities that allow programmers to perform high-level actions on date variables, including date arithmetic.

Conversion functions convert from one datatype to another, often formatting the output data at the same time.

LOB functions allow operations on LOB (large object) data.

Miscellaneous functions perform operations that don't fall into any of the other categories.

Nevin Alencherry

• Dec 15th, 2006

 

Types of functions in OracleAggregate functions Avg, Count, Sum, RankAnalytic Functions Lag, Lead, Ratio_to_report, First_value, Last_valueCharacter Functions Instr, Trim, Length, Lower, Upper, Replace, TranslateConversion Functions To_char, To_date, To_number, ConvertDate Functions Add_months, Last_day, Trunc, Round, Next_dayError Reporting Functions Sqlcode, SqlerrmNumeric Functions Abs, Ceil, Floor, Mod, Round, SignMiscellaneous Functions Coalesce, Decode, Dump, Greatest, Least, Nvl, User, VsizeObject Reference Functions Deref, Make_ref, Ref, Reftohex, Value