＋设为首页 ＋添加到收藏夹
请问如何向oracle数据库中导入一张嵌套表？请高手指点！谢谢！
a interesting example :
1.
create or replace type ANIMAL_TY as object
(Breed VARCHAR2(25),Name VARCHAR2(25),Birthdate DATE);
2.
create type ANIMALS_NT as TABLE of ANIMAL_TY;
3.
create table BREEDER
(BreederName VARCHAR2(25),
Animals ANIMALS_NT)
nested table ANIMALS store as ANIMALS_NT_TAB);
4.
insert into BREEDER values
(Jane James,
ANIMALS_NT(
ANIMAL_TY(DOG, BUTCH, 31-MAR-97),
ANIMAL_TY(CAT, PUS, 02-FEB-99)
));
commit;
