可是这样的表结构可以用来存储什么东西呢? 比如说 create type doertype as object(name varchar2(20),age number(4)); create type doerlist is table of doertype; create table doernest(userid varchar2(20),UM doerlist) nested table UM store as doertable; 这样的表结构
CREATE TYPE phone AS TABLE OF NUMBER; / CREATE TYPE phone_list AS TABLE OF phone; / CREATE TABLE my_customers ( name VARCHAR2(25), phone_numbers phone_list) NESTED TABLE phone_numbers STORE AS outer_ntab (NESTED TABLE COLUMN_VALUE STORE AS inner_ntab);
(NESTED TABLE COLUMN_VALUE STORE AS inner_ntab); 这句是什么意思啊?
比如说
create type doertype as object(name varchar2(20),age number(4));
create type doerlist is table of doertype;
create table doernest(userid varchar2(20),UM doerlist)
nested table UM store as doertable;
这样的表结构
/
CREATE TYPE phone_list AS TABLE OF phone;
/
CREATE TABLE my_customers (
name VARCHAR2(25),
phone_numbers phone_list)
NESTED TABLE phone_numbers STORE AS outer_ntab
(NESTED TABLE COLUMN_VALUE STORE AS inner_ntab);
这句是什么意思啊?