Lesson plan

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.

Back to article

Article summary

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.

Key claims

No claims recorded.

Discussion questions

  1. Summarise the article in your own words. Which single claim would you verify first, and why?
  2. Which claim in this article is most likely to be revised as the sources update? How would you check its current status?
  3. If two sources disagreed about one of these facts, what would you need in order to trust one over the other?

Bibliography

No sources recorded.

Key claims and bibliography are generated from the same tracked claims and sources as the article page.