Collections

PL/SQL collections are the equivalent of arrays in Oracle. A PL/SQL collection is a composite data type consisting of elements accessible through an index value.

Oracle XML Object-Relational Storage

Oracle XML Object-Relational Storage [EXAMPLE]

Object-relational storage of XML data in Oracle is based on shredding the XML data into SQL objects. Scripts and stepwise execution for object-relational XML storage.

Read the Full Article →
Thumbnail image for The Smart Way to Check if an Element Exists in a Collection

The Smart Way to Check if an Element Exists in a Collection

Oracle 10G onwards, the set operator MEMBER OF can be applied to test if an element exists in a collection or not. You do not need to loop through all elements in the collection to find a match.

Read the Full Article →

How to Perform MULTISET Operations on Nested Table of Objects

PL/SQL with MULTISET operations on nested table of objects throws up the error ‘PLS-00306: wrong number or types of arguments…’. This workaround lets you use MULTISET operations successfully with complex types.

Read the Full Article →
Thumbnail image for MULTISET Operations: Combining Nested Tables Made Easy

MULTISET Operations: Combining Nested Tables Made Easy

Oracle 10G onwards, MULTISET operations using UNION, INTERSECT, MINUS can work as single-step set operations on PL/SQL nested tables without procedural code for row-by-row comparison. Here’s how.

Read the Full Article →
Thumbnail image for An Easy Guide to PL/SQL Collections

An Easy Guide to PL/SQL Collections

Oracle PL/SQL collections are of three types: Index By Tables, Nested Tables, Varrays. Here’s a comparison chart of the types of PL/SQL collections based on parameters such as size, ease of modification, and persistence.

Read the Full Article →