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…
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…
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…
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…
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…
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…
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…
Commit: Commit command is used to commit or save transaction permanently. It is similar to a save command of other windows based application. When we apply commit command all the transaction andRead More…
It is easy to create a new table from the existing table instead of specifying a new structure. It creates a new table with the column specified into the select query. ItRead More…
IN clause can be use for searching operation. It searches for the records with specific criteria. It displays those records that are matches with the values specified into the IN clause. ItRead More…
Oracle allows facility to access records that matches specific pattern. It can be helpful when we don’t know the exact form of data that we want to search. Oracle uses “LIKE” predicateRead More…