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 is a server parameter file in oracle?

815


What is the difference between "as" and "is" in an oracle stored procedure?

773


How to execute a stored procedure in oracle?

845


Explain the blob datatype?

822


What to do if the startbd.bat failed to start the xe instance?

852


How to increment dates by 1 in oracle?

795


How to write date and time literals in oracle?

770


What are the logical operations?

905


State any two functions of oracle?

823


How to convert character types to numeric types?

801


What do you mean by cdb and pdb in oracle 12c?

847


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

2351


Are truncate and delete commands same? If so why?

864


How to update values in a table in oracle?

781


What happens if you lost a data file?

820