Running on Oracle Database 19c
Running on Oracle Database 23ai
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.
887,047 scripts, 3,984 likes, 1,036 published scripts, 4 new scripts created in the last 7 days.