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>
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