DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: can We delete master record???????????

  1. #1
    Join Date
    Aug 2000
    Posts
    4

    Angry

    HI,
    I am new to Oracle I have a question,
    Can a user delete a master record with knowing the child table or record, if so can anybody suggest me
    Balaji.P

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    The answer is (as is so often the case) "it depends". If there is no foreign key constraint or triggers to enforce the parent/child relationship, then the user can absolutely delete the parent row.
    If there is a foreign key constraint, the user MAY be prevented from doing so. However, there are ways to tell Oracle to DELETE all child rows or set all child rows to NULL first - which essentially kills or orphans all of the child rows so that deleting the parent row creates no conflict.
    I recommend you read the Oracle Concepts Manual - in this case, the chapter on integrity constraints.

Posting Permissions

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


Click Here to Expand Forum to Full Width