[PHP] Cascading delete in oracle

2003-02-21 Thread Raven Eve
create table Shop( ordId NUMBER(7) NOT NULL PRIMARY KEY); create table Customer( ordId NUMBER(7) NOT NULL, FOREIGN KEY (ordId) REFERENCES Shop(ordId) on delete cascade); so, when i delete a row in shop, the corresponding row in customer will be deleted. so, i have created a function in php to ex

[PHP] Cascading delete in oracle and php

2003-02-21 Thread Raven Eve
hi, i have 2 tables in oracle create table Shop( ordId NUMBER(7) NOT NULL PRIMARY KEY); create table Customer( ordId NUMBER(7) NOT NULL, FOREIGN KEY (ordId) REFERENCES Orders(ordId) on delete cascade); so, when i delete a row in shop, the corresponding row in customer will be deleted. so, i hav