Nested SQL: Difference between revisions

Revision as of 22:35, 19 May 2009

Latest revision as of 09:43, 4 March 2025

(11 intermediate revisions by 6 users not shown)

Line 1:

{{about|tables as column data|nested queries|Correlated subquery}}

A '''nested table''' is a [[Table (database)|table]] that is embedded within another table.

AIn [[relational databases]], a '''nested table''' is a [[Table (database)|table]] that is embedded within another table.

Individual elements can be inserted, updated, and deleted in a nested table. Since individual [[Element (mathematics)|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.

Individual elements can be inserted, updated, and deleted in a nested table. Since individual [[Element (mathematics)|elements]] can be modified in a nested table, they are more flexible than an [[array data structure|array]] because elements in an array can only be modified as a whole, not individually.

==See also==

*[[Query optimizer]]

A nested table doesn't have a maximum size, and an arbitrary number of elements can be stored in it.

==External links==

*{{cite web

*[http://blogs.ittoolbox.com/oracle/guide/archives/oracle-collections-a-definition-in-plain-english-part-2-6003 Oracle Collections: A Definition in Plain English Part 2]

|url=https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/nested-tables-analysis-services-data-mining?view=sql-server-2017

*[http://www.oraclepressonline.com/toc.jsp?bookid=8172&prevbkid=&nextbkid= Oracle Database 10g: SQL (Oracle Press)]

|title=Nested Tables (Analysis Services - Data Mining)

|date=2018-05-07

|df=mdy-all

|website=Microsoft

}}

*{{cite web

|url=https://docs.oracle.com/database/121/LNPLS/composites.htm#GUID-5ADB7EE2-71F6-4172-ACD8-FFDCF2787A37

|title=PL/SQL Collections and Records: Nested Tables

|work=Oracle Database Online Documentation Library, 12c Release 1 (12.1.0.2)

|year=2017

}}

*[{{cite web|url=http://blogs.ittoolbox.com/oracle/guide/archives/oracle-collections-a-definition-in-plain-english-part-2-6003 |title=Oracle Collections: A Definition in Plain English Part 2]|archive-url=https://web.archive.org/web/20060701234934/http://blogs.ittoolbox.com/oracle/guide/archives/oracle-collections-a-definition-in-plain-english-part-2-6003|archive-date=2006-07-01|df=mdy-all}}

*[{{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}}

[[Category:Database management systems]]

[[Category:SQL]]

[[Category:Relational database management systems]]