I am trying to delete a row from DEMOGRAPHICS table, but it has integrity constraint. I need to delete dependencies first. I do see SQL error such as:
ORA-02292: integrity constraint (xxx_xxx.FK_xxx_xxx) violated - child record found.
How do I find child record and delete it?
I am using oracle SQL developer.