niladri.biswas

Let Us Learn Oracle - Part 16 of N [ Greatest and Least function in Oracle ]
Source table: tblStudents
Purpose: Finds the Greatest and the Least number from a range of numbers
Example of Greatest function
SQL> Select Greatest(10,20,4,56,234,999,12,56,-45,23,77,123) GreatestNumber From Dual;......

Let Us Learn Oracle - Part 12 of N [ NVL function in Oracle ]
Source table: tblPlayers
Purpose: It substitute a value when a null value is encountered.
Syntax: NVL( ColumnName, ReplaceValue )
Where,
ColumnName => It is the column that is use for null value test.
ReplaceValue => Value that w......

Let Us Learn Oracle - Part 6 of N [ RPad and LPad function in Oracle ]
Source table: tblPlayers
RPad
Syntax: RPad(InputString,length,[,set])
Purpose: Pads the right side of the column with the given character. It fills the display to the given length. If InputString is longer than length, s......

An Introduction to SSIS Balanced Data Distributor Transformation Component
Table of Content
Introduction
How it Works
Adding Balanced Data Distributor(BDD) in the SSIS toolbox
Let us look an example
When to use the BDD
References
Conclusion
Introduction
Microsoft has released ......

In Denali (SQL Server 2012) CTP 3, the Over clause has been enhanced a lot. Let us look into them as below
a.Rows and Range
These keywords specifies that the function will be applied for every row a window use for calculating the function result. The Rows specifies the window in physical units wh......