Nested Tables

CREATE TYPE proj_t AS OBJECT(
Projno Number, Projname varchar(20)) 

CREATE TYPE proj_list AS TABLE OF proj_t

CREATE TYPE employee_t AS OBJECT( Eno number,Projects proj_list)

CREATE TABLE employees OF employee_t(eno PRIMARY KEY) NESTED TABLE projects STORE AS employees_proj_table;

INSERT INTO employees VALUES(1, proj_list (proj_t(1,'A'), (proj_t(2,'B'), (proj_t(3,'C')))));

SELECT e.eno, p.projno
FROM employees e, TABLE(e.projects) p