hi i am in need of some assistance for my project ASAP . I am using SQL*Plus in Oracle 8.1.7 and am trying to restrict the deletion of rows from the parent relation "players" if the playerno is in the teams table. I have tried using the "ON DELETE CASCADE " and that works fine. How come the ON DELETE RESTRICT does not work??? I have also tried to use ON DELETE NO ACTION with no luck. PLEASE HELP !!
I have attached my code below for your refrernce:

CREATE TABLE teams
(teamno INT NOT NULL,
playerno INT NOT NULL,
division VARCHAR2(10) NOT NULL,
PRIMARY KEY(teamno),
FOREIGN KEY(playerno) REFERENCES players(playerno) ON DELETE RESTRICT);