Deleting a row with foreign keys
I'm using Orcale8i and I'm trying to delete a row from a table that contains foreign keys. I know that the foreign key relationship needs to be removed before the row can be deleted, but I'm not sure how to do this. Do I need to you use CASCADE CONSTRAINTS after my DELETE statement? I don't want to delete the foreign key relationships from the entire table, just from a selected record.