Insert values into simple collections and nested collections

When you insert values into a row that contains a collection column, you insert the values of all the elements that the collection contains as well as values for the other columns. For example, the following statement inserts a single row into the manager table, which includes columns for both simple collections and nested collections:

INSERT INTO manager(mgr_name, department, 
   direct_reports, projects)
   VALUES 
(
'Sayles', 'marketing', 
"SET{'Simonian', 'Waters', 'Adams', 'Davis', 'Jones'}", 
LIST{
   ROW('voyager_project', SET{'Simonian', 'Waters',
   'Adams', 'Davis'}), 
   ROW ('horizon_project', SET{'Freeman', 'Jacobs',
   'Walker', 'Smith', 'Cannan'}), 
   ROW ('saphire_project', SET{'Villers', 'Reeves',
   'Doyle', 'Strongin'})
   }
);