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
- 4870 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 the relationship among database, tablespace and data file?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
Youre getting high busy buffer waits - how can you find whats causing it?
Can you drop an index associated with a unique or primary key constraint?
How many types of synonyms in Oracle?
what is main def between plsql/table and array?
How to rename a column in an existing table?
What is a nested table and how is it different from a normal table?
how to handle exceptions in post production
What is the string concatenation operator in oracle?
Do View contain Data ?
Describe varray?
Oracle General 
