SQL Query Processing Let us discuss what happens inside oracle when we write a SQL query and press the green color execute button on the SQL Developer [Continue Reading…]
Setup for ROLLUP and CUBE ROLLUP and CUBE are used very rarely in our traditional OLTP systems.But it is always better to have such functions [Continue Reading…]
GROUP BY Functions in Oracle We will have an overview of the functionality available for aggregation in data warehouses Setup The examples in this article will [Continue Reading…]
PIVOT Function in Oracle The Oracle PIVOT clause allows you to write a cross-tabulation query starting in Oracle 11g. This means that you can aggregate [Continue Reading…]
Cardinality in Oracle Cardinality means the number of something but it gets used in a variety of contexts. It depends a bit on context. When [Continue Reading…]
error: Content is protected !!