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
- 5001 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 |
Difference between open_form and call_form in oracle.
Explain what are synonyms used for?
What the is the diff between local index and global index. give some example.
difference between truncate and delete ,drop?
In the oracle version 9.3.0.5.0, what does each number shows?
How to recover a dropped table in oracle?
Explain what does a control file contain?
which sql command we can use to get a print out from oracle?
how do get database name at sql prompt?
Why we choose emp number as primarykey?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Oracle General 
