Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Array Columns

happy10319Mar 10 2019 — edited Mar 10 2019

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;

pastedImage_0.png

Is array unsupported??

Otherwise why this message: Unsupported data type?

How can I have an array in a column?

Thanks.

This post has been answered by mathguy on Mar 10 2019
Jump to Answer
Comments
Post Details
Added on Mar 10 2019
8 comments
5,791 views