Oracle Live SQL
  • Help
  • Sign In
  • Home
  • SQL Worksheet
  • My Session
    • Previous Sessions
    • Utilization
    • NLS
  • Schema
  • Quick SQL
  • My Scripts
  • My Tutorials
  • Code Library
LiveSQL Logo

Learn and share SQL

Now running on Oracle Database 19c

Featured Scripts and Tutorials

  • Introduction to SQL

    This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create tables with primary keys, columns, constraints, ind...

    Tutorial
  • Simple Explain Plan

    This script explains the plan for a query of the sh.sales and sh.products tables.

    Script
  • 19C LISTAGG DISTINCT

    The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows...

    Script
  • 19c JSON_OBJECT

    Syntax simplifications are offered for SQL/JSON path expressions, SQL/JSON generation with function json_object, and field projection with SQL/JSON ne...

    Script

359,463 scripts, 2,448 likes, 959 public scripts, 3,261 new scripts created in the last 7 days.

© 2019 Oracle Corporation · Privacy · Terms of Use
Oracle Learning Library · Oracle Database Documentation 18c , 12c · Follow on Twitter
Live SQL 19.4.1, running Oracle Database 19c Enterprise Edition - 19.4.0.0.0
Built with love using Oracle APEX