Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> on delete set default feature

on delete set default feature

From: dondora <koninja_at_bluebottle.com>
Date: Fri, 15 Jun 2007 16:55:32 -0700
Message-ID: <1181951732.498838.314930@i38g2000prf.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US