Sql – Delete a child and a parent row with one SQL script


Instead of deleting the child row and then writing another sql statement to delete the parent row I wanted to use one statement which will do both. FYI: we use Oracle database.

Update: I dont have a privilege to do DELETE ON CASCADE

Best Solution

Define your foreign keys with cascading deletes. Then you only need to delete the "parent" row.