How can we Update a table with out using UPDATE command?

Question Posted / amulbaby

How can we Update a table with out using UPDATE command?..

Answer / 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

More Oracle General Interview Questions

What are the general rules on data consistency?

State any two functions of oracle?

How to name query output columns in oracle?

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

what are actual and formal parameters?

Point the difference between translate and replace?

What is oracle latest version?

How to run the anonymous block again?

How to use subqueries with the in operator using oracle?

How to define and use table alias names in oracle?

What is the difference between truncate & delete command?

What is an oracle cursor variable?

For more Oracle General Interview Questions Click Here