CREATE TYPE Categories AS OBJECT(
priority VARCHAR2(10),
subcategory VARCHAR2(60)
); Type created.
CREATE TYPE CategoriesList AS TABLE OF Categories; Type created.
CREATE TABLE projekt (
projektname VARCHAR2(10),
categories CategoriesList)
NESTED TABLE categories STORE AS categories_tabTable created.
INSERT INTO projekt VALUES('a',CategoriesList(Categories('1','subcat1'),
Categories('2','subcat4'),
Categories('3','subcat5')))1 row(s) inserted.
INSERT INTO projekt VALUES('b',CategoriesList(Categories('1','subcat1'),
Categories('2','subcat3'),
Categories('3','subcat5')))1 row(s) inserted.
INSERT INTO projekt VALUES('c',CategoriesList(Categories('1','subcat1'),
Categories('2','subcat2')))1 row(s) inserted.
select * from projekt| PROJEKTNAME | CATEGORIES | a | [unsupported data type] | b | [unsupported data type] | c | [unsupported data type] |
|---|
select t.*
from projekt p,
table (p.categories) t| PRIORITY | SUBCATEGORY | 1 | subcat1 | 2 | subcat4 | 3 | subcat5 | 1 | subcat1 | 2 | subcat3 | 3 | subcat5 | 1 | subcat1 | 2 | subcat2 |
|---|