Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

oracle - SQL, On delete cascade and on update cascade

I am new to SQL and I encountered a weird problem. So I have two tables OFFERS and SUPPLIER. Here is the Supplier table.

CREATE TABLE  "SUPPLIER" 
   (    "S#" NUMBER, 
    "NAME" VARCHAR2(50),  
    "CITY" VARCHAR2(50), 
     PRIMARY KEY ("S#") ENABLE
   )

And here is the OFFERS table.

CREATE TABLE  "OFFERS" 
   (    "P#" NUMBER, 
    "S#" NUMBER, 
    "V#" NUMBER, 
    "PR#" NUMBER, 
      CONSTRAINT "PK_OFFERS" PRIMARY KEY ("P#") ENABLE
   )

So now, when I try to add a Foreign key constraint to the offers table like this

ALTER TABLE OFFERS
ADD CONSTRAINT FK_SUPPLIERS FOREIGN KEY(S#)
 REFERENCES SUPPLIER (S#) 
ON DELETE CASCADE
ON UPDATE CASCADE

I get an error saying : "ORA-01735: invalid ALTER TABLE option". If I remove the last line, which is "ON UPDATE CASCADE" this works perfectly fine. So, what am I doing wrong? I've seen a lot of examples like this on the internet, that are supposed to work, so I am kinda confused. I am working on apex.oracle.com if that makes any difference.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

There is no "on update cascade" in Oracle as far as I know (even in current versions):

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5773459616034


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...