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
- 5091 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 Network Database link ?
Is truncate autocommit in oracle?
How to delete a user account in oracle?
Can you create a synonym without having a table?
What are operators in oracle?
What happens if variable names collide with table/column names?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What is an oracle data file?
what is the difference between functional dependecy and multilevel dependency?
Explain the use of analyse option in exp command.
Give the constructs of a package, function or a procedure.
Oracle General 
