How to delete a row with all foreign keys

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rohullah
    New Member
    • Mar 2010
    • 43

    How to delete a row with all foreign keys

    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.
Working...