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.

External links

• "Nested Tables (Analysis Services - Data Mining)". 2018-05-07. https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/nested-tables-analysis-services-data-mining?view=sql-server-2017. 
• "PL/SQL Collections and Records: Nested Tables". Oracle Database Online Documentation Library, 12c Release 1 (12.1.0.2). 2017. https://docs.oracle.com/database/121/LNPLS/composites.htm#GUID-5ADB7EE2-71F6-4172-ACD8-FFDCF2787A37. 
• "Oracle Collections: A Definition in Plain English Part 2". http://blogs.ittoolbox.com/oracle/guide/archives/oracle-collections-a-definition-in-plain-english-part-2-6003. 
• "Oracle Database 10g: SQL (Oracle Press)". http://www.oraclepressonline.com/toc.jsp?bookid=8172&prevbkid=&nextbkid=. 

0.00 (0 votes) Original source: https://en.wikipedia.org/wiki/Nested SQL. Read more