[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
uj5u.com熱心網友回復：
你上面定義的是animals_nt，下面參考的是animal_ntuj5u.com熱心網友回復：
感謝2樓幫我發現低級錯誤,修改后,依舊是報錯.還請大家麻煩幫我再看一下[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
uj5u.com熱心網友回復：
我這建了一遍，沒問題了～
uj5u.com熱心網友回復：
感謝大家幫助 問題已經解決
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 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')));
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/39905.html
標籤：基礎和管理