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