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 execution control statements?
What is data file?
Is it possible to insert comments into sql statements return in the data model editor ?
candidate key is subset of super key but not vice-verse explain
What is a cursor and what are the steps need to be taken?
Explain the use of ignore option in imp command.
How to initialize variables with default values?
Differentiate between post-database commit and post-form commit?
Describe an oracle table?
List the types of joins used in writing subqueries?
How to convert numbers to characters in oracle?
Why do we need integrity constraints in a database?
How a tablespace is related to data files?
What is SQL access advisor in Oracle?
How do you find current date and time in oracle?