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.
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,575,513 scripts, 5,321 likes, 1,067 published scripts, 7,956 new scripts created in the last 7 days.