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.
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 are the different types of trigger and explain its various uses and functions?
What are the basic element of Base configuration of an oracle Database ?
Explain oracle’s server parameter file.
What are the data types in oracle?
What is background process in Oracle?
What is a package in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
what is difference between table and view? where to use views? thanks in advance!
does the query needs a hint to access a materialized view?
How many memory layers are in the oracle shared pool?
Can we create trigger on view in oracle?
Describe varray?