Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select + insert vs. insert and catching exception
I stand corrected. You *can* modify the value of a PK (must be that lack
of intelligence). However, you'd still face having to change the phone
number in any table where it's a FK if you change it where it's a PK.
Jaap W. van Dijk wrote:
> On Thu, 26 Sep 2002 15:55:02 GMT, Karsten Farell
> <kfarrell_at_medimpact.com> wrote:
>
> (...)
>
>>In Oracle, you cannot modify the value >>of a PK.