How many rows do you have in your table?
Michael Peel
-----Original Message-----
From: TABAKU Dritan
[mailto:oracledba-ezmlmshield-x50334781.[Email address protected]
Sent: 31 March 2008 12:41
To: LazyDBA Discussion
Subject: RE: Update issue!
Hello
I run the following, but it takes a lot of time.
How can I perform faster this update?
Br
________________________________________
Dritan TABAKU
BCCS Unit, IT Department
AMC, ALBANIA
mobile:+355 (0) 682053050
e-mail:: [Email address protected]
-----Original Message-----
From: Jagannathan Gowrish
[mailto:oracledba-ezmlmshield-x50104688.[Email address protected]
Sent: Monday, March 31, 2008 12:40 PM
To: LazyDBA Discussion
Subject: RE: Update issue!
Begin
For I in ( select id from customers where id > 10000 )
Loop
Update customers set customer_address = 'null' where id = I.id;
End loop
End;
-----Original Message-----
From: TABAKU Dritan
[mailto:oracledba-ezmlmshield-x13777965.[Email address protected]
Sent: Monday, March 31, 2008 4:05 PM
To: LazyDBA Discussion
Subject: Update issue!
Hello Experts,
I want to update a table with the specific value.
The problem is that I can't update them all 100000 rows.
I want to update them one by one.
Can anyone provide me a script or a solution how can I do it?
Example:
Update customers set customer_address = 'null' where id > 10000
Thanks
________________________________________
Dritan TABAKU
BCCS Unit, IT Department
AMC, ALBANIA
mobile:+355 (0) 682053050
e-mail:: [Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
Oracle LazyDBA home page