Well, I`m kinda new to this whole oracle thing, so the answer to my question is hopefully obvious to most of you.
I`ve created some types and tables, and everything worked out allright until I was gonna insert data into my table. The nested table within it doesn`t seem to act as a nested table since I can only choose one value.
Here is the code and I`m really stuck on this so I hope someone will respond.
CREATE OR REPLACE TYPE fagfelt_multi as object(
CREATE OR REPLACE TYPE fagfelt_nested_multi as table of fagfelt_multi;
CREATE OR REPLACE TYPE boktyp1 AS OBJECT(
forlagsnavn ref forlagstyp,
forfatter ref persontype1
CREATE TABLE boktab of boktyp1
NESTED TABLE fagfelt STORE AS fagfelt_multi_ntbl(
ORGANIZATION INDEX COMPRESS)RETURN AS LOCATOR;
ALTER TABLE boktab
ADD CONSTRAINT pkbok PRIMARY KEY (isbn);
INSERT INTO boktab
FROM forlagstab G, persontab E
WHERE E.navn=personntyp('Geir', 'Nilsen')
I can get it to work, but only with one value in fagfelt_nested_multi(fagfelt_multi, which sorta works against the purpose since its supposed to be multivalued.
In advance thanks ^
Edit: realized after posting that it`s saturday night, so did what I should of done in the first place, searched the topic, and realized the sollution was close.