November 4, 2016RDBMSoracle-functions, sql-functionsDreamMaker Oracle provides number of in-built functions. Oracle functions can be divided into two broad categories: Scalar functions Scalar functions are those functions that operates on individual row. It can be categories as follows. String Handling Functions Conversion Functions Date Functions Numeric Functions 2. Aggregate Functions