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

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

Explain the characteristics of oracle dba?

How will you differentiate between varchar & varchar2?

defination of bitmap index

what are stored procedures?

How to put more than 1000 values into an oracle in clause?

What are Clusters ?

How would you best determine why your MVIEW couldnt FAST REFRESH?

How to view the data files in the current database?

What are the differences between blob and clob in oracle?

What is a table index in oracle?

what is the difference between no rows returned and null returned?

For more Oracle General Interview Questions Click Here