GROUP BY Functions in Oracle
GROUP BY Functions in Oracle We will have an overview of the functionality available for aggregation in data warehouses Setup The...
September 4, 2016
Database
PIVOT Function in Oracle
PIVOT Function in Oracle The Oracle PIVOT clause allows you to write a cross-tabulation query starting in Oracle 11g. This...
September 4, 2016
Cardinality and Index in Oracle
Cardinality in Oracle Cardinality means the number of something but it gets used in a variety of contexts. It depends...
September 4, 2016
Partitioned Tables And Indexes in Oracle
Partitioned Tables And Indexes Maintenance of large tables and indexes can become very time and resource consuming. At the same...
September 4, 2016
RANK, DENSE_RANK, FIRST and LAST Analytic Functions
Lets talk about how to use RANK, DENSE_RANK, FIRST and LAST Analytic Functions. The concept is very very simple. RANK,...
September 2, 2016