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: oracle-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…
Numeric Function
ABS () It returns absolute value of the given values. Syntax: ABS (Val); Example: SELECT abs (-15) FROM DUAL ; Output: 15 Power () It returns power of Mn where m isRead More…
Date Function
Add_Month: It returns date after adding specifies number of months in to the given dates. Syntax: Add_Month (date, month); Example: SELECT add_Month (sysdate, 3) FROM DUAL ; Output: 15-Aug-2016 ; Last_Day: ItRead More…
String Handling Functions
Upper(): It returns specified string into the upper case. Syntax: Upper(String or Filed); Example: SELECT upper(‘Welcome’) FROM DUAL; // with constant String SELECT upper(firstName) FROM EMP ; // where firstName is aRead More…