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.
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 |
State and explain the different types of data models?
State the various uses of dbcc command?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is a cursor variable?
How do we represent comments in oracle?
How to create a new oracle data file?
Explain the use of file option in exp command.
Can you tell me how to add new column in existing views?how?How is possible?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How do I start tns listener?
How to define a sub function?
How to divide query output into groups in oracle?