hi dear all,
i have table which reference with multiple other tables
and it do not have ON DELETE CASCADE so now i want to delete this row without disabling the constraints.
delete from account where account_no=201
i am trying the above query it give me the following errors
Error starting at line : 13 in command -
delete from account where account_no=201
Error report -
SQL Error: ORA-02292: integrity constraint
please i need help in urgent
thanks in advance.
i have table which reference with multiple other tables
and it do not have ON DELETE CASCADE so now i want to delete this row without disabling the constraints.
delete from account where account_no=201
i am trying the above query it give me the following errors
Error starting at line : 13 in command -
delete from account where account_no=201
Error report -
SQL Error: ORA-02292: integrity constraint
please i need help in urgent
thanks in advance.