relational databases A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured form ...

, a nested table is a

table Table may refer to: * Table (database), how the table data arrangement is used within the databases * Table (furniture), a piece of furniture with a flat surface and one or more legs * Table (information), a data arrangement with rows and column ...

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 An array is a systematic arrangement of similar objects, usually in rows and columns. Things called an array include: {{TOC right Music * In twelve-tone and serial composition, the presentation of simultaneous twelve-tone sets such that the ...

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

* * * *{{cite web, url=http://www.oraclepressonline.com/toc.jsp?bookid=8172&prevbkid=&nextbkid= , title=Oracle Database 10g: SQL (Oracle Press), archive-url=https://web.archive.org/web/20050908164422/http://www.oraclepressonline.com/toc.jsp?bookid=8172, archive-date=2005-09-08, df=mdy-all Database management systems SQL Relational database management systems