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

oracleparentparent-childsql

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 Answer

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