i've run into a small problem.
It might be that the solution is obvious, and i just don't see it.
I have a bunch on tables.
I wish to delete a row from the PARENT table, and each corresponding rows from the 3 CHILDX tables.
If the relationship was the other way around, i would just smack a ON DELETE CASCADE constraint on, and live happily ever after.
Does anyone have a suggestion which could point me in the right direction?
I know i essentially have 3 parents and 1 child here, and that the best solution would probably be to inverse the relationship, but this is unfortunatly not an option for me.
btw this is on Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 if that matters
Thank you in advance for your time.