コレクション型は苦手
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