Introduction to SQL This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create t...

SQL 101 Script Name SQL 101 Description Full database schema with tables, views, sequences, packages, procedures, functions, et all Area SQL General Contributor Mike Hichwa (Oracle) Created …

Note: all database objects start with "plch" indicating that this script was taken from the Oracle Dev Gym (formerly known as the PL/SQL Challenge): https://devgym.oracle.com

Utility to Find Placeholders in Dynamic SQL Strings In the most complicated dynamic SQL scenarios (method 4), you may not know how many bind variables y...

Table Functions and Ref Cursors Script Name Table Functions and Ref Cursors Description DML in a table function with a REF CURSOR as a parameter. Thats a lot going on. Area PL/SQL General / …

Description With 12.2's enhancement to PL/Scope to also gather data on SQL statements in your PL/SQL code, it's a snap to find all COMMIT and ROLLBACK statements in your code!

First Time Run Script Name First Time Run Description sysdate, build a table, populate a table, run a select * from Area SQL General Contributor That Jeff Smith (Oracle) Created Monday October 05, 2015

Named notation - explicitly associating the formal parameter with its actual value - is a sweet feature of PL/SQL, but it should not be NECESSARY to get your code to compile. Unfortunately, that's what it …

Script Name sequence generator Description generate sequence & reverse sequence generate alternating sequence generate sequence of x Area SQL General Contributor klipare Created Friday …

Oracle Live SQL