Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> on delete set default feature
hi.
I want to create tables like below.
CREATE TABLE Member(memberNo INTEGER, registeredDate DATE, rating
INTEGER
, age INTEGER, sex CHAR(10), name CHAR(20), ssn CHAR(20), cellNo
CHAR(20)
, phoneNo CHAR(20), address CHAR(100), note CHAR(100)
, PRIMARY KEY(memberNo));
CREATE TABLE Staff(employedDate DATE, staffNo INTEGER
, age INTEGER, sex CHAR(10), name CHAR(20), ssn CHAR(20), cellNo
CHAR(20)
, phoneNo CHAR(20), address CHAR(100), note CHAR(100),
PRIMARY KEY(staffNo));
CREATE TABLE President(age INTEGER, sex CHAR(10), name CHAR(20), ssn
CHAR(20)
, cellNo CHAR(20), phoneNo CHAR(20), address CHAR(100), note
CHAR(100));
CREATE TABLE Operation(operationNo INTEGER, operationName CHAR(20)
, operationPrice INTEGER, kindsOfOperation CHAR(20), note CHAR(100)
, PRIMARY KEY(operationNo));
CREATE TABLE OperationDetails(memberNo INTEGER DEFAULT 9999, staffNo
INTEGER DEFAULT 9999
, operationNo INTEGER, operationDate DATE
, PRIMARY KEY(memberNo, staffNo, operationNo)
, FOREIGN KEY(memberNo) REFERENCES Member ON DELETE SET DEFAULT
, FOREIGN KEY(staffNo) REFERENCES Staff ON DELETE SET DEFAULT
, FOREIGN KEY(operationNo) REFERENCES Operation);
CREATE TABLE ReserveDetails(memberNo INTEGER DEFAULT 9999, staffNo
INTEGER DEFAULT 9999
, reserveDate DATE, operationName CHAR(20), note CHAR(100)
, PRIMARY KEY(staffNo, memberNo)
, FOREIGN KEY(memberNo) REFERENCES Member ON DELETE SET DEFAULT
, FOREIGN KEY(staffNo) REFERENCES Staff ON DELETE SET DEFAULT);
CREATE TABLE TakesChargeOf(staffNo INTEGER DEFAULT 9999
, memberNo INTEGER DEFAULT 9999
, PRIMARY KEY(staffNo, memberNo)
, FOREIGN KEY(staffNo) REFERENCES Staff ON DELETE SET DEFAULT
, FOREIGN KEY(memberNo) REFERENCES Member ON DELETE SET DEFAULT);z
But errors has occured like this.
, FOREIGN KEY(staffNo) REFERENCES Staff ON DELETE SET DEFAULT
*
ORA-03001: unimplemented feature
Can't I use 'ON DELETE SET DEFAULT' feature in ORACLE? Received on Fri Jun 15 2007 - 18:55:32 CDT
![]() |
![]() |