Re: Update primary key

Kevin wrote:
>
> Hi,
> I'm a newbie in Oracle. I would like to ask if a primary key of a table
> can be updated because someone told me it's illegal to update any primary
> keys.
> Any post / FAQ response are welcome.
> Thanx

You can update the primary key - but if this is a common occurrence you'd be better using a synthetic key for primary key

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse