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.
Sources and credits
This article is adapted from the Wikipedia article “Nested SQL”, written by its contributors and licensed under CC BY-SA 4.0. Fathomly has changed the layout, removed citation markers, navigation and maintenance notices, and adjusted punctuation. This adapted version is shared under the same license. For references, see the original article.
Fathomly is not affiliated with or endorsed by the Wikimedia Foundation. Spotted a problem? Tell us.