|
|
-
|
|
Indicates how the data is ordered within the partition.
Example 1: Find next r......
|
|
-
|
|
Let Us Learn Oracle - Part 34 of N [ Dump function of Oracle ]
It extracts the column details of the column from the table.
Select
BelongsTo,Dump(BelongsTo) "Dump BelongsTo",
PlayerId,Dump(PlayerId) "Dump PlayerId" ,
DOB,Dump(DOB) "Dump DOB"
From tblPlayers;
/* Result */
B......
|
|
-
|
|
Let Us Learn Oracle - Part 33 of N [ Tree Structure query by using Oracle's Connect By clause ]
This clause creates a report on inheritence tree structure data.
We will look into the TSql Challenge #8 and will solve that by using this clause
SQL> Select LPAD(' ' ,Level * 4) || EMPNAME "Employe......
|
|
-
|
|
Let Us Learn Oracle - Part 32 of N [ Cube function of Oracle ]
Purpose: It gives a cross tabulated summary of detail rows. It calculates subtotals for all possible combinations of group parameters.It also calculates the grand total.
Select DeptName,BelongsTo, Count(*) "Departmentwise Employee",......
|
|
-
|
|
Let Us Learn Oracle - Part 31 of N [ RollUp function of Oracle ]
Purpose: Calculates multiple level of subtotals across a specified group of dimensions.It also calculates the grand total.
Select DeptName,BelongsTo, Count(*) "Departmentwise Employee", Avg(Salary) "Deptwise Avg Sal"
From tblEmpl......
|
|
-
|
|
Let Us Learn Oracle - Part 30 of N [ VSize function of Oracle ]
Purpose: It returns the number of bytes in the internal representation of expression. If expression is null, it returns null.
SQL> Select EMPNAME, VSize(EMPNAME) VSizeExample
2 From tblemployee;
EMPNAME ......
|
|
-
|
|
Let Us Learn Oracle - Part 29 of N [ Collect function of Oracle 10g ]
Introduce in Oracle 10g,this function comes under the category of Collection function. It helps to aggregate data into a collection. This function takes a column of any type as it's input argument and creates a nested table f......
|
|
-
|
|
Let Us Learn Oracle - Part 28 of N [ How to create and use Temporary table in Oracle ]
Oracles temporary tables are statically defined.They are created once per database and not for individual stored procedures in the database.It is created in the user temporary table space.
Temporary tables in......
|
|
-
|
|
With Cte1 As
(
Select * From tblPlayers
)
Select *
From Cte1
Order By PlayerID;
PLAYERID PLAYERFIRS PLAYERLAST BELONGSTO DOB FEEPERMATCH
---------- ---------- ---------- ---------- --------- -----------
1 A Raman India 2......
|
|
-
|
|
Let Us Learn Oracle - Part 26 of N [ Undocumented Overlap function of Oracle ]
Purpose: Helps to find out if a date range overlaps.
Syntax: (StartDateOfFirstDateRange,EndDateOfFirstDateRange) Overlaps (StartDateOfSecondDateRange,EndDateOfSecondDateRange)
Consider the below first
SQL> Select ......
|
|