How to update rows in table, suppose i have lacks of rows in table how to upda

How to update rows in table, suppose i have lacks of rows in
table how to update total table with update statement.
Can u please any one answer this question with update
statement.

Question Posted / siva

2 Answers
4285 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to update rows in table, suppose i have lacks of rows in table how to update total table with ..

Answer / kt

If you go for a direct update statement, it will hang (as u
have indicated that ur table has lakhs of records).
So its better to analyze the table or go for dbms_stats.
After that fire ur update statement
update <table_name> set <column_name> = .......
where ...........

Is This Answer Correct ?

3 Yes

3 No

How to update rows in table, suppose i have lacks of rows in table how to update total table with ..

Answer / anil

write on anonyms block...
create one cursor and update the rows in a table with the
help of cursor...bcs ur table size is very large.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer