cutting the varray of the picture. I was first trying with another kind of object, but the problem was the same so I wondered if the VARRAY was easier, but now I see it isn't.
And if instead of a VARRAY, I've got something like:
CREATE TYPE demo AS OBJECT (age NUMBER, birth_place VARCHAR(25));
CREATE TABLE test
(id NUMBER(10,0) NOT NULL,
What is the solution? Others may benefit from seeing it. I can't see how you can get a particular row (e.g. 2nd) from a nested table unless you have another column in it to number the rows. You can easily get all the rows, or the row where age=25, but not "the first row" or "the second row" in any meaningful sense.