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
- 4971 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 |
Display Odd/ Even number of records?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to export your connection information to a file?
What is a deadlock ? Explain .
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What privilege is needed for a user to query tables in another schema?
What are the ways tablespaces can be managed and how do they differ?
What is index-organized table in Oracle?
Briefly explain what is literal? Give an example where it can be used?
What is oracle in java?
What are advantages fo Stored Procedures?
what is the syntax of SELECT command?
Oracle General 
