create or replace type TYPE_1 as OBJECT ( OBJ_1 CHAR, OBJ_2 NUMBER ); / create or replace type t_var is varray(10) of TYPE_1;create table TEST_M ( COLUMN_1 T_VAR );SQL> select a.OBJ_1,a.OBJ_2 from test_m,table(column_1) a; OBJ_1 OBJ_2 ----- ----------
(
OBJ_1 CHAR,
OBJ_2 NUMBER
);
/
create or replace type t_var is varray(10) of TYPE_1;create table TEST_M
(
COLUMN_1 T_VAR
);SQL> select a.OBJ_1,a.OBJ_2 from test_m,table(column_1) a; OBJ_1 OBJ_2
----- ----------