Re: updation on primary key ?????

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 14 Jan 2004 08:16:16 -0800
Message-ID: <40056B50.4020907_at_x.washington.edu>


KULJEET wrote:
> the default property of block level of updation
> is
> Update Changed Columns Only property=NO
> it means when u will update only one field in form.
> and oracle will update all column of table
> ALSO UPDATE PRIMARY KEY (OH NOOOOOOOOOOO)
> IT MEANS IT WILL LOCK ON CHILD TABLES ;
>
> IS THIS BEHAIVOUR IS OK IN LARGE APPLICATION???????????????
> PLZ GUIDE
>
> THANKS
> kuljeet pal singh

[Quoted] This behavior is one that should ALWAYS be changed.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jan 14 2004 - 17:16:16 CET

Original text of this message