Hi Experts,

I am having a customer linked to many tables like card,account,bank etc .How can i delete all the related data of a particular customer in single query?

Can anyone pleasse give me some hint ?

TIA

You cannot do it is a "single" statement--unless all of your RI is setup up to do it for you. You can however do it in an atomic block of statements:

--Turn off autocommit if it is on
Delete from all child tables in the proper order
delete from parent table
commit
--Turn on autocommit if applicable

Andy