Code Library - Oracle Live SQL

Script

Binding PLSQL Types in SQL (12.1 and Higher)

In 12.1, Oracle Database extended its support for PL/SQL-specific datatypes in SQL statements. Befor...

BINDING

9 82

9.6 years ago Steven Feuerstein

Script

SQL on Collections

"Hi Steven, what is the best way to perform operations like SELECT a, SUM(b) from t GROUP BY a that ...

table operator

4 66

9.4 years ago Steven Feuerstein

Script

Simple Table Function Example: Collection of Scalars

A table function is a function executed with the TABLE operator, and then within the FROM clause of ...

table function

2 52

9.1 years ago Steven Feuerstein

Script

Nested Table Example

Demonstrates how to declare a schema-level nested table type, extend to make room for news and popul...

NESTED TABLE

4 42

9.7 years ago Mike Hichwa (Oracle)

Script

Accessing index of associative array in SELECT-FROM TABLE() operation

As of Oracle Database 12c Release 1, you can now use the TABLE operator with associative arrays whos...

TABLE,INDEX VALUE

2 39

9.3 years ago Steven Feuerstein

Script

Demonstration of Streaming Table Function

What is a streaming table function? Well, first, a table function is a function executed with the TA...

STREAMING,TABLE FUNCTION

2 29

9.4 years ago Steven Feuerstein

Script

Use TABLE Operator with Associative Arrays in Oracle Database 12c (for blog post)

This script "backs up" the post written by Steven Feuerstein demonstrating the use of TABLE with ass...

12c,12.1,collection,table

1 24

7.8 years ago Steven Feuerstein

Script

Sort Associative Arrays Using SQL (12.1)

Starting with 12.1, you can apply the TABLE operators to associative arrays indexed by integer (inde...

SORT,associative,array,12c

0 16

9.4 years ago Steven Feuerstein

Script

Schema-level Nested Tables

Creating schema-level nested tables and using table operator to operate with them.

0 8

6.5 years ago merce_jance

Script

12c: Skip the TABLE Operator w/Table Functions

As of 12.1, you can now call table functions in the FROM clause of a query without nesting it inside...

table function

0 7

8.4 years ago Steven Feuerstein

Script

12.2 new feature - TABLE operator not needed for PTF

Small example to demonstrate that the TABLE operator is not needed anymore in a 12.2 environment for...

12.2, feature demo

2 4

8 years ago Sven Weller