09:45:30 SQL> Create Type acct_jfh_0913 As Object
09:45:31 2 (
09:45:31 3 acct_id Varchar(10),
09:45:31 4 serv_id Varchar(10),
09:45:31 5 cust_id Varchar(10)
09:45:31 6 );
09:45:36 11 /类型已创建。已用时间: 00: 00: 00.81
09:45:39 SQL> Create Type acct_jfh_lst As Table Of acct_jfh_0913;
09:45:51 2 /类型已创建。已用时间: 00: 00: 00.47
09:46:16 SQL> Create Table nestedtable_test (
09:46:27 2 acct_item_type_id Varchar(10),
09:46:30 3 acct_test_jfh acct_jfh_lst
09:46:33 4 )
09:46:37 5 Nested Table acct_test_jfh Store As acct_test_jfh_tab; 表已创建。已用时间: 00: 00: 00.63
09:46:40 SQL>
09:45:31 2 (
09:45:31 3 acct_id Varchar(10),
09:45:31 4 serv_id Varchar(10),
09:45:31 5 cust_id Varchar(10)
09:45:31 6 );
09:45:36 11 /类型已创建。已用时间: 00: 00: 00.81
09:45:39 SQL> Create Type acct_jfh_lst As Table Of acct_jfh_0913;
09:45:51 2 /类型已创建。已用时间: 00: 00: 00.47
09:46:16 SQL> Create Table nestedtable_test (
09:46:27 2 acct_item_type_id Varchar(10),
09:46:30 3 acct_test_jfh acct_jfh_lst
09:46:33 4 )
09:46:37 5 Nested Table acct_test_jfh Store As acct_test_jfh_tab; 表已创建。已用时间: 00: 00: 00.63
09:46:40 SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货