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
- 5012 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 does the on-delete-cascade statement work?
What is a table in oracle?
What are the execution control statements in oracle?
What is ordinary table in oracle?
How to write a query with an inner join in oracle?
What is SQL access advisor in Oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are a cluster and non-cluster index?
What are transaction isolation levels supported by oracle?
What do you mean by merge in oracle and how can we merge two tables?
Explain a segment?
How to delete a column in an existing table in oracle?
What is the fastest query method to fetch data from the table?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Explain an exception?
