Code Library - Oracle Live SQL

Skip to Main Content

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.4 years ago Mike Hichwa (Oracle)
Script
Using Multiset with emp and dept tables

Converting database table to nested table using MULTISET

MULTISET

3 38

6.2 years ago merce_jance
Script
MULTISET UNION Examples

Use MULTISET UNION to perform set-level union operations on nested tables. Remember: with MULTISET, ...

collection,nested table,multiset,union

0 22

6.5 years ago Steven Feuerstein
Script
MULTISET EXCEPT Examples

Use MULTISET EXCEPT to perform a set-level "minus" operation involving two nested tables. MULTISET E...

MULTISET,EXCEPT,MINUS

0 19

9 years ago Steven Feuerstein
Script
Comparing Nested Tables with SQL Multiset Conditions

This uses the SQL multiset conditions and two SQL functions that take nested table variable argument...

LNPLS

1 19

7.9 years ago Sarah Hirschfeld (Oracle)
Script
Assigning Set Operation Results to Nested Table Variable

This example assigns the results of several MULTISET operations and one SET function invocation of t...

LNPLS

0 19

8.1 years ago Sarah Hirschfeld (Oracle)
Script
Demonstration of SUBMULTISET Operator

Use SUBMULTISET with nested tables to determine if one nested table is contained within another.

SUBMULTISET,Nested table

0 16

9.4 years ago Steven Feuerstein
Script
MULTISET example

use of MULTISET EXCEPT, INTERSECT, UNION on collection type of nested table. For a complex type ...

MULTISET EXCEPT INTERSECT UNION

0 14

8.8 years ago Amit Shah
Script
MULTISET INTERSECT Examples

Use MULTISET INTERSECT to perform a set-level intersect operation involving two nested tables. MULTI...

MULTISET,INTERSECT

0 13

9 years ago Steven Feuerstein
Script
MULTISET Comparisons and Map Methods

The MULTISET operators are fantastic, declarative, set-oriented functionality for nested tables. But...

multiset,compare,nested table,object type

1 10

6.4 years ago Steven Feuerstein
Script
Set operations with PLSQL Nested Tables

Set operations with PLSQL Nested Tables using MULTISET

MULTISET

0 5

6.2 years ago merce_jance
Script
Impact of NULLs on Nested Table MULTISET Operations

You can perform set-level operations on nested tables using the MULTISET operators (example: MULTISE...

MULTISET,NULL

0 3

9 years ago Steven Feuerstein

row(s) 1 - 12 of 12