Insert into a nested collection

If you want to insert into a nested collection, the syntax of the VALUES clause changes. Suppose, for example, that you want to insert a value into the twin_primes column of the numbers table that Figure 1 shows.

With the twin_primes column, you might want to insert a SET into the LIST or an element into the inner SET. The following sections describe each of these tasks.


Copyright© 2019 HCL Technologies Limited