Nested SQL
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.
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
[edit]- "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.