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
- 4878 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to write a query with a left outer join in oracle?
What are the parameters that we can pass through a stored procedure?
How to define an anonymous procedure with variables?
Explain a private synonyms?
What is an oracle user role?
How to pass a parameter to a cursor in oracle?
What is meant by joins?
how to join query for one source type is oracle another source type is sql server ?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to use "while" statements in oracle?
How to convert character types to numeric types?
How to get last row id?
What is a table index?
What's dateware house and what's clustor with practicle example
what is the scenario where you take the database to NoArchivelog mode?
