The F_CASCADE_DELETE function generates the list of DELETE commands, goes cascading down the foreing key references. Use the result list to check and delete or update the referenced rows from bottom ...

When the application user tries to delete a row that is referenced directly or indirectly in a child table by a foreign key with a delete_rule of 'NO ACTION', then the ... With Oracle SQL Developer ...