SQL Tutorials, Tips & Tricks

45 Useful Oracle Queries

45 Useful Oracle Queries

Here’s a list of 40+ Useful Oracle queries that every Oracle developer must bookmark. These queries range from date manipulation, getting server info, get execution status, calculate database size etc. Date / Time related...

Row Data Multiplication in Oracle

Row Data Multiplication in Oracle

Aggregate functions return a single result row based on a group of rows. This differentiates them from Single-Row functions which act on each row. These functions are extensively used with the GROUP BY clause...