Syntax of the VALUES clause

The syntax of the VALUES clause is different when you insert into an SPL collection variable from when you insert into a collection column. The syntax rules for inserting literals into collection variables are as follows:

• Use parentheses after the VALUES keyword to enclose the complete list of values.
• If you are inserting into a simple collection, you do not need to use a type constructor or brackets.
• If you are inserting into a nested collection, you need to specify a literal collection.