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
- 4871 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 Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
How to convert characters to dates in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to get a list of all background sessions in the database?
Can objects of the same Schema reside in different tablespaces.?
What are the factors causing the reparsing of SQL statements in SGA?
What is the difference between an Oracle Schema and an Oracle Instance?
What is the difference between alert log file and tarce file ?
State and explain about oracle instance?
What happens if you set the sga too low in oracle?
What is a initialization parameter file in oracle?
what is primary key and foreign key when and where have to use
Oracle General 
