RE: Update issue!

Update customers set customer_address = null where id > 10000;

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: TABAKU Dritan
[mailto:oracledba-ezmlmshield-x50334781.[Email address protected]
Sent: Monday, March 31, 2008 7:41 AM
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

Oracle LazyDBA home page