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
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter