Oracle Functions
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 asRead More…
Tag Archives: sql-functions
Aggregate Function
Aggregate functions are those functions that can be apply on multiple rows and returns signal result for all rows. They are also known as grouping functions. Oracle provides the following aggregate function.Read More…
Conversion Function
Conversion function are used to convert one data type value into another data type. to_number(): It converts character value in to the numeric data type. Syntax: to_number (char); Example: SELECT to_number (substrRead More…