Oracle PL/SQL Concepts
- BLOCK
- declare …. Begin…End.
- Cursor
- Trigger
- Programming Clauses:
- if..then…else, case when, loops (for, while)
- Stored Procedure
- Function
- Advanced SQLs and Analytics Functions
- GROUP BY ROLLUP(), GROUP BY CUBE()
- RANK(), DENSE_RANK(), ROW_NUMBER()
- PARTITION_BY, ORDER BY X NULLS Last, ORDER BY X NULLS FIRST, RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL ‘30’ DAY Following
- Hierarchical: Connect Prior
- Windowing Functions: RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL ‘30’ DAY Following
- Grouping Sets
