0

Can someone suggest a way to generate delete queries for various tables linked via foreign key constrains for Oracle ? A solution for SQLServer is mentioned here

Copied description from the original question :

I have the table: DelMe(ID) and there are 30 tables with fk references to its ID that I need to delete first, is there some tool/script that I can run that will generate the 30 delete statements based on the FK relations for me ?

gaurs
  • 575
  • 1
  • 5
  • 19
  • Maybe a stupid answer, but you might consider defining the FKs with cascade delete. – Robert Kock Jan 11 '19 at 10:12
  • @RobertKock : Actually as it happens in most of such cases, I do not have the luxury to update the schema as its a legacy application that we need to support. – gaurs Jan 11 '19 at 10:21

0 Answers0