Need help with constraints in Oracle 7 (desperate)

• Quoting Eric Douglas to All dated 06-12-94 ***
  > The problems start when trying to update the column department.name.
  

First, it must be said that updating a primary key column is not a normal thing to do, and usually indicates that either something is wrong with your model or your front end.

> I really don't want to change the LDD of my database, just to
> accomodate Oracle 7. I'm hoping that some Oracle 7 programmer out there who
> knows more about Oracle than I do can give me an answer on how to
> implement these integrity constraints on the database, without imposing
> rules saying that primary or referenced columns cannot be updated.

Most schools of relational theory will tell you that if it can be updated, then it is NOT a primary key.

Let's assume, though, that you have legitimate reasons for wanting to do so -- a simple insert, and then delete, will do it. Received on Tue Jun 14 1994 - 21:58:00 CEST