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
- 5014 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 |
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to connect the oracle server as sysdba?
what happened to the global index when I truncate the data in one of the partition?
How to find the duplicate rows count from employees table in oracle?
What is an Oracle Instance?
How to write date and time literals in oracle?
what are different types of deletes?
How to write a query with a left outer join in oracle?
What types of joins are used in writing subqueries?
How do you find current date and time in oracle?
State the difference between a primary key and foreign key?
How a tablespace is related to data files?
Oracle General 
