Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5087 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is a sub query and what are the different types of subqueries?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What is Index and different types of Indexes?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
what are the database links ?
What are various joins used while writing SUBQUERIES?
What is instant client oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to use "in out" parameter properly?
How does Oracle guarantee data integrity of data changes?
defination of bitmap index
Can we convert a date to char in oracle and if so, what would be the syntax?
Oracle General 
