 ,         Customer,   Orders, ,   ,   Lines.          ,    ,   .
      ,    . ,    ,     ,           .  ,   ,    ,      (OID)  ,        .
       :
CREATE OR REPLACE TYPE staff_assignment_t AS TABLE OF         staff_assignment_o;
CREATE TABLE projects
( proj_id      NUMBER        PRIMARY KEY
, proj_name    VARCHAR2(30)  NOT NULL
, manager     NUMBER       NOT NOLL REFERENCES project_members
, assignments  staff_assignment_t --   
, roi         BFILE   --      NESTED TABLE assignments STORE AS project_assignments;
,   NESTED TABLE        ,    Oracle.
  ,   VARRAY,      SQL   , ,     ,   .  ,         .   :
INSERT INTO THE
(SELECT assignments FROM projects WHERE proj_id = 555) VALUES {34, 'Ol-SEP-96', '30-SEP-961, 2000);
  ,           .       SQL  THE    ,    .
  ?
    ?     (VARRAY   ) ?
           ,      .  
106	Oracle 8