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;
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;
这在命令提示符下是不行的,只有在sql*plus中才可以啊。也就是说,这个不是oracle
标准类型中的啊。如果我用jdbc,那这样不就不行了嘛。