Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexes and Foreign Keys

Re: Indexes and Foreign Keys

From: Mark A <nobody_at_nowhere.com>
Date: Sat, 11 Mar 2006 16:39:06 -0700
Message-ID: <Cv6dnWdyaJAHwo7ZRVn-pw@comcast.com>


"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message news:Xns97839AB4B1665ianalvistahotmailcom_at_70.169.32.36...

>

> Please provide a functioning example SQL statement that 'changes' a PK
> value.

We are not talking about MS Access or other toy databases. You can certainly update a PK.

You may be restricted if there are FK's attached to the PK on a child table, depending on how you define FK. Received on Sat Mar 11 2006 - 17:39:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US