SQL statement for Deleting

I have created two databases USERS and ORDER:  

USERS have the following tables:
login , primary key
fullname
num

and the ORDER has:
login
orderno
where foreign key(login) references users

So ORDER is dependent on the USERS database When I try to delete from the USERS database user which exists also in the HOBBBY, error message : ORA-02292: integrity constraint violated - child record found.

So I have to delete that particular user from the HOBBY database in order to delete it from the USERS database.

Is there SQL statement that also deletes particular user from all the child databases.

Thanks for help! Received on Thu Jul 25 1996 - 00:00:00 CEST