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


Please Help Members By Posting Answers For Below Questions

What are the execution control statements?

827


What is data file?

816


Is it possible to insert comments into sql statements return in the data model editor ?

2334


candidate key is subset of super key but not vice-verse explain

1793


What is a cursor and what are the steps need to be taken?

799


Explain the use of ignore option in imp command.

776


How to initialize variables with default values?

873


Differentiate between post-database commit and post-form commit?

785


Describe an oracle table?

798


List the types of joins used in writing subqueries?

761


How to convert numbers to characters in oracle?

788


Why do we need integrity constraints in a database?

773


How a tablespace is related to data files?

801


What is SQL access advisor in Oracle?

863


How do you find current date and time in oracle?

791