Jump to content

Nested SQL

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Victor falk (talk | contribs) at 07:17, 23 September 2007 (Category:SQL Category:MySQL). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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 a varray because elements in a varray 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.

See also