November 4, 2016RDBMSoracle-functions, sql-functionsDreamMaker

• Oracle provides number of in-built functions.
• Oracle functions can be divided into two broad categories:

1. 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