Gblog

おもにTips

コレクション型は苦手

 

 

create or replace type TYPE0 as object ( id number,data varchar2(100));
/
create or replace type TYPE0_TABLE AS TABLE OF TYPE0;
/
/
create table typesample1 ( testcol1 TYPE0);
create table typesample2 ( testcol1 TYPE0_TABLE ) nested table testcol1 store as testcol1nt;

set lin 120 pages 1000
col data_type for a60
col type_name for a30
col typecode  for a30
select data_type, count(*) total from user_tab_columns group by data_type ;
select type_name, typecode from user_types ;

 

 結果

 

SQL> select data_type, count(*) total from user_tab_columns group by data_type ;

DATA_TYPE                                                         TOTAL
------------------------------------------------------------ ----------
TYPE0                                                                 1
TYPE0_TABLE                                                           1

SQL> 
SQL> select type_name, typecode from user_types ;

TYPE_NAME                      TYPECODE
------------------------------ ------------------------------
TYPE0                          OBJECT
TYPE0_TABLE                    COLLECTION