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
- 5092 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
What do you mean by merge in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to use existing values in update statements using oracle?
How to get execution path reports on query statements?
How to build data dictionary view an new database?
What is difference between sid and service name in oracle?
How to select some rows from a table in oracle?
How many types of tables supported by oracle?
How to create a new view in oracle?
How to execute a stored program unit?
What are the different windows events activated at runtime ?
Why we use bulk collect in oracle?
How to connect to a local oracle 10g xe server?
How to convert csv to table in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
