帮忙呀！！谢谢！！！

Question

SQL> insert into new_table 
SQL> values(1,new_type(1,2,3,4,5,6,7,8,9,10));1 row insertedSQL> commit;Commit completeSQL> select * from new_table;                                      A B
--------------------------------------- -
                                      1 <
                                      1 <
                                      1 <

Answer 1

SQL> create type new_tpye as varray(10) of number
  2  /
类型已创建
SQL> create table new_table(a integer, b new_tpye);
表已创建
SQL> insert into new_table values (1,new_tpye(1,2,3,4,5,6,7,8,9,10));
已创建 1 行写上类型名（值....） 就行

Answer 2

SQL> select a,b.* from new_table,table(b) b;                                      A COLUMN_VALUE
--------------------------------------- ------------
                                      1            1
                                      1            2
                                      1            3
                                      1            4
                                      1            5
                                      1            6
                                      1            7
                                      1            8
                                      1            9
                                      1           1010 rows selected