This article is about tables as column data. For nested queries, see Correlated subquery.

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.

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.

📚 Artikel Terkait di Wikipedia

Query optimization

In some cases such nested SQL queries can be flattened into a select-project-join query, but not always. Query plans for nested SQL queries can also be

Nested set model

The nested set model is a technique for representing nested set collections (also known as trees or hierarchies) in relational databases. It is based

Select (SQL)

Queries can be nested so that the results of one query can be used in another query via a relational operator or aggregation function. A nested query is also

PL/SQL

PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle

PostgreSQL

database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation,

MySQL

MySQL (/ˌmaɪˌɛsˌkjuːˈɛl/) is a free and open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder

First normal form

table, in SQL) can be said to be in first normal form if each field is atomic, containing a single value rather than a set of values or a nested table. In

Database transaction

Transactions are available in most SQL database implementations, though with varying levels of robustness. For example, MySQL began supporting transactions