hi, i am just the beginner with oracle 10g, so plz don't laugh out loud to see my tiny tables...
CREATE TABLE stud(
id varchar(10) NOT NULL,
CREATE TABLE address(
address varchar(10) NOT NULL,
FOREIGN KEY(id) REFERENCES stud
ON DELETE NO ACTION
the output of it is ORA-00905: missing keyword
the same output appears if i make it ON DELETE RESTRICT.
i know ON DELETE NO ACTION is the default. and also i found that oracle 9i and higher supports these twos. ON DELETE CASCADE is doing fine. what's wrong?
If you do not specify ON DELETE part at all, you will not be able to delete stud if it exists in any address row (exception is thrown). I think it matches required RESTRICT behaviour. I have no idea what NO ACTION should do.