Code Library - Oracle Live SQL

Tutorial

Creating Time Series Calculations in Analytic Views

This tutorial provides examples for creating time series calculations such as prior periods, year ag...

analytic view, time series, LEAD, LAG, SHARE_OF

25 2,086

8.5 years ago William Endress (Oracle)

Script

Analytics - LAG and LEAD functions

SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...

kiss, windows, oracle, analytics, lag, lead

15 511

9.3 years ago Connor Mcdonald (Oracle)

Script

Analytics - In-list processing

SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...

lag, lead, kiss, oracle, sql, analytics

7 222

9.2 years ago Connor Mcdonald (Oracle)

Script

Analytics - LAG and LEAD extensions

SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...

lag, lead, kiss, oracle, sql, analytics

6 215

9.3 years ago Connor Mcdonald (Oracle)

Script

LAG analytic function example

LAG is an analytic function. It provides access to more than one row of a table at the same time wit...

lag

13 158

9.7 years ago Mike Hichwa (Oracle)

Script

The $$PLSQL_UNIT and $$PLSQL_TYPE Conditional Compilation Flags

These pre-defined conditional compilation flags, or ccflags, return the name and type of the program...

CCFLAG,CONDITIONAL COMPILATION

5 143

9.2 years ago Steven Feuerstein

Script

Observing Spending Time of Separately Querying COUNT(*|1|id|flag) on some Test Tables

This demo usually uses to observe the spending time of separately querying COUNT(*), COUNT(1), COUNT...

Spending Time Querying COUNT table

0 28

5.5 years ago Quanwen Zhao

Script

Ask Tom: Sample LAG query

0 13

8.9 years ago Rumtis

Script

Group user sessions by time

Given a list of user_ids and log_dates, bucket the session into increments of 10 min (upto an hour)....

user session, web log

0 11

7.1 years ago lavjain

Script

named_not_null_constraint

How can I name a "not null" constraint that sets the NULLABLE flag in DBA/USER_TAB_COLUMNS?

0 6

8.1 years ago Don Simpson

Script

Function based unique index not working

This is an example of a function based index to avoid duplicates usernames when there is a logical d...

1 5

7.4 years ago Homer

Script

Function LAG- Eduardo Alves

Exemplificando a utilização da função LAG, onde, basicamente irá retornar o salário e a função irá m...

LAG

0 4

8 years ago Eduado Soares Alves

Script

Use Conditional Compilation to Test Private Subprograms

There is no way to unit test subprograms defined in the package body. But if you really want to, you...

conditional compilation,test

0 3

7 years ago Steven Feuerstein

Script

Show Compilation Parameters

Demonstration of (and resusable procedure) compilation parameters that can be referenced as conditio...

compile,parameters,conditional

0 3

6.2 years ago Steven Feuerstein

Script

Use Compile-Time Warnings to Detect Runtime Errors

This is one of my favorite warnings: PLW-6017. Something bad is your way coming! This catch-all warn...

error,warning,plw,runtime

0 2

7.3 years ago Steven Feuerstein