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
- 4972 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 numeric literals in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How many types of table in Oracle?
What is an oracle recycle bin?
What is materialized view in Oracle?
why dont we assign not null constraint as table level constraint.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is Library Cache in Oracle?
Explain the use of file option in exp command.
How to convert csv to table in oracle?
What are the common oracle dba tasks?
How to invoke the data pump export utility?
Is insert autocommit in oracle?
Explain an index segment?
How many types of tables supported by oracle?
