Hi,
On Oracle Live Sql
I created and fullfil a table as follow:
CREATE TYPE list AS VARRAY(100) OF int;
create table test (id NUMBER(18) GENERATED BY DEFAULT AS IDENTITY, action char(2),status char(2),nra int NULL,list_se list NULL);
insert into test (action,status) values ('NA','p');
insert into test (action,status) values ('SE','VS');
But I have :
select * from test;

Is array unsupported??
Otherwise why this message: Unsupported data type?
How can I have an array in a column?
Thanks.