How can we Update a table with out using UPDATE command?
Answer Posted / myway
Use merge command. If the rows already exist then it will
update it with new data if not it would insert the new data.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of oracle?
How to pass a cursor variable to a procedure?
What are the different editions of oracle?
defination of bitmap index
What do you mean by a deadlock?
Write a trigger example in oracle?
Explain the use of grant option in imp command.
What is bind variable in oracle 11g?
What is a directory object?
What is flashback in Oracle?
What are dml statements in oracle?
How to increment dates by 1 in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Explain implicit cursor.