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 is a server parameter file in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
How to execute a stored procedure in oracle?
Explain the blob datatype?
What to do if the startbd.bat failed to start the xe instance?
How to increment dates by 1 in oracle?
How to write date and time literals in oracle?
What are the logical operations?
State any two functions of oracle?
How to convert character types to numeric types?
What do you mean by cdb and pdb in oracle 12c?
Is it possible to insert comments into sql statements return in the data model editor ?
Are truncate and delete commands same? If so why?
How to update values in a table in oracle?
What happens if you lost a data file?