Nested SQL

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

In relational databases, a nested table is a table that is embedded within another table.

Individual elements can be inserted, updated, and deleted in a nested table. Since individual elements can be modified in a nested table, they are more flexible than an array because elements in an array can only be modified as a whole, not individually.

A nested table doesn't have a maximum size, and an arbitrary number of elements can be stored in it.

External links

"Nested Tables (Analysis Services - Data Mining)". Microsoft. May 7, 2018.
"PL/SQL Collections and Records: Nested Tables". Oracle Database Online Documentation Library, 12c Release 1 (12.1.0.2). 2017.
"Oracle Collections: A Definition in Plain English Part 2". Archived from the original on July 1, 2006.
"Oracle Database 10g: SQL (Oracle Press)". Archived from the original on September 8, 2005.