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.
This article is mirrored from “Nested SQL” on English Wikipedia, revision 1278745854, written by Wikipedia's contributors and licensed CC BY-SA 4.0. Editing it here creates a Quire copy with its own history.
Synced with Wikipedia revision 1278745854 · just now