[SQL]CREATE TYPE animal_ty AS OBJECT (
breed VARCHAR2 (25),
NAME VARCHAR2 (25),
birthdate DATE
);
CREATE TYPE animals_nt AS TABLE OF animal_ty ;
CREATE TABLE breeder (
breedername VARCHAR2 (25),
animals animal_nt
) NESTED TABLE animals STORE AS animals_nt_tab ;
[Err] ORA-24344: success with compilation error
breed VARCHAR2 (25),
NAME VARCHAR2 (25),
birthdate DATE
);
CREATE TYPE animals_nt AS TABLE OF animal_ty ;
CREATE TABLE breeder (
breedername VARCHAR2 (25),
animals animal_nt
) NESTED TABLE animals STORE AS animals_nt_tab ;
[Err] ORA-24344: success with compilation error
[SQL]CREATE TYPE animal_ty AS OBJECT (
breed VARCHAR2 (25),
NAME VARCHAR2 (25),
birthdate DATE
);
CREATE TYPE animal_nt AS TABLE OF animal_ty ;
CREATE TABLE breeder (
breedername VARCHAR2 (25),
animals animal_nt
) NESTED TABLE animals STORE AS animals_nt_tab ;
[Err] ORA-24344: success with compilation error
breed VARCHAR2 (25),
NAME VARCHAR2 (25),
birthdate DATE
);
/CREATE TYPE animal_nt AS TABLE OF animal_ty ;
/CREATE TABLE breeder (
breedername VARCHAR2 (25),
animals animal_nt
) NESTED TABLE animals STORE AS animal_nt_tab ; -- ----------------------------
-- Records of breeder
-- ----------------------------
insert into breeder values('mary',animal_nt(animal_ty('dog','butch','31-MAR-97'),animal_ty('dog','rover','31-MAR-97'),animal_ty('dog','julio','31-MAR-97')));
insert into breeder values('jane',animal_nt(animal_ty('cat','an','31-MAR-97'),animal_ty('cat','jame','31-MAR-97'),animal_ty('cat','killer','31-MAR-97')));