CREATE TYPE my_type AS VARRAY(100) OF DATE;
CREATE TABLE testus(ID INT,dt my_type);
INSERT INTO testus(ID,dt) VALUES(1,my_type(SYSDATE,to_date('96,2,14','yy,mm,dd')));
INSERT INTO testus(ID,dt) VALUES(2,my_type(SYSDATE,to_date('96,2,14','yy,mm,dd')));
SELECT x.* from table(SELECT dt FROM testus s WHERE ID=1)x
COLUMN_VALUE | 25.11.2009 17:49:47 | 14.02.2006 |
|
SELECT y.id,x.* from table(SELECT dt FROM testus s WHERE ID=y.ID)x,testus y
Ora-00904:invalid column name
Oracle 8.1.7