   ,      100   ,    Projects:
CREATE OR REPLACE TYPE staff_assignment_v AS VARRAY (100) OF   staff_assignment_o; CREATE TABLE projects
( proj_id    NUMBER         PRIMARY KEY
, proj_name  VARCHAR2(30)   NOT NULL
, manager    NUMBER        NOT NULL REFERENCES project_members
, assignments staff_assignment_v   100 
, roi BFILE --     
) ;
 staff_assignment_v  -,    100 ,        staff_assign-ment,    NULL.       ,  SQL- INSERT  UPDATE.
:
     VARRAY  ,      ,  Oracle     VARRAY   ,             .
     VARRAY     PL/SQL:
p_assigns staff_assignment_v;
SELECT assignments INTO p_assigns
FROM projects WHERE proj_id = 42;
       .                .
 
 " " (nested tables)         ,        .    OracleS     .       ,         .    .  ,
5. 	105