Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    22

    Red face Unanswered: Delete Query??? Please help...thanks

    Hi,

    I have the table: R1(A, B, C)

    Primary Key (A, B)
    Foreign Key (A)

    I'm trying to delete a row using the query: delete from R1 where A = 123;

    However, Oracle freezes on me. Please help. Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Guwahati, India
    Posts
    33

    Please Note

    Your public key A , may have parent value in the other table. you can delete the parent value first and then delete the one you want. Or you can try delete (table name) where a=123 cascade ;


    G J Shankar Nath
    System Admin
    GNRC Limited
    G J Shankar Nath
    IT Consultant, Vedswasti Services Pvt. Ltd
    Guwahati-781007
    India

  3. #3
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    I feel the rows are locked

    try a commit / rollback before shooting delete

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •