Running on Oracle Database 19c
This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create tables with primary keys, columns, constraints, ind...
This tutorial explains how to create a parameterized view using SQL Macros. The examples use the built-in sales history schema so there are no setup s...
This shows you how to find gaps in rows containing start/end dates using match_recognize. You can make this a reusable SQL fragment by placing this in...
This script explains the plan for a query of the sh.sales and sh.products tables. Both statements must be executed at the same time in order to get t...
The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows...
An overview of how to combine SQL pattern matching with SQL macros to create reusable code fragments.
1,734,601 scripts, 5,586 likes, 1,072 published scripts, 8,184 new scripts created in the last 7 days.