04Nov/16

Oracle Functions

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 asRead More…

04Nov/16

Aggregate Function

November 4, 2016RDBMSaggregate-functions, oracle-functions, sql-functionsDreamMaker

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…

01Nov/16

Numeric Function

November 1, 2016RDBMSmath-function, numeric-function, oracle-functionsDreamMaker

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…

01Nov/16

Date Function

November 1, 2016RDBMSconversion-function, date-functions, oracle-functionsDreamMaker

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…

01Nov/16

Conversion Function

November 1, 2016RDBMSconversion-function, oracle function, sql-functionsDreamMaker

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…

06Oct/16

String Handling Functions

October 6, 2016RDBMSfunctions, oracle-functions, string-handling-functionsDreamMaker

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…

27Sep/16

Transaction Control Language Statements (TCL)

September 27, 2016RDBMScommit, rollback, savepoint, tclDreamMaker

 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…

17Sep/16

Creating new table from existing table

September 17, 2016RDBMScreating-new-table, insert-record-from-existing-tableDreamMaker

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…

10Sep/16

IN / NOT IN Clause

September 10, 2016RDBMSin, not-inDreamMaker

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…

29Aug/16

LIKE Predicate (pattern matching)

August 29, 2016RDBMSlike, pattern-matchingDreamMaker

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…