This page discusses variations of inserting in Oracle using the PL/SQL Programming language.
Inserting Records into the Varying Array
When a datatype is created, the database automatically creates a method called a constructor method for the datatype. You need to use the constructor method when inserting records into columns that use an abstract datatype. Since a varying array is an abstract datatype, you need to use constructor methods to insert records into tables that use varying arrays. Furthermore, since the varying array is itself an abstract datatype, you may need to nest calls to multiple constructor methods to insert a record into a table that uses a varying array. The columns of the BORROWER table are Name and Tools, the last of which is a varying array using the TOOLS_VA datatype. The following command will insert a single record into the BORROWER table. In this example, the record will have a
single Name column value and three Tools values.
insert into BORROWER values