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 is an oracle transaction?

Find all employees in Dept “Marketing”.

What are the different approaches used by Optimizer in choosing an execution plan ?

types of indexes and the rationale behind choosing a particular index for a situation.

Why is oracle used?

How to invoke the data pump import utility?

Does oracle partitioning improve performance?

What is a named program unit?

How to use in conditions in oracle?

What is partitioned table in Oracle?

How to retrieve data from an cursor to a record?

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

For more Oracle General Interview Questions Click Here