- What are nested tables and why are they needed?
- What is a nested table and how is it different from a normal table?
What are nested tables and why are they needed?
A nested table is represented in the case table as a special column that has a data type of TABLE. For any particular case row, this kind of column contains selected rows from the child table that pertain to the parent table. The data in a nested table can be used for prediction or for input, or for both.
What is a nested table and how is it different from a normal table?
A nested table is an unordered set of data elements, all of the same datatype. No maximum is specified in the definition of the table and the order of the elements is not preserved. You select, insert, delete, and update in a nested table just as you do with ordinary tables using the TABLE expression.