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
- 4496 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 |
How to create a new table in your schema?
What are the uses of synonyms?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the syntax of update command?
Explain the difference between a procedure and a function? What do you understand by those terms?
What operating systems are supported by oracle database 10g xe?
What is oracle update statement with inner join ?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What is tns name?
What is a data dictionary and how can it be created?
What are the limitations oracle database 10g xe?
How to create a table index in oracle?
Oracle General 
