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

How do I connect to oracle database?

what is exact difference between drop and truncate table.

What do you understand by a database object? Can you list a few of them?

How to drop an existing table in oracle?

How to retrieve the count of updated rows?

What is recovery manager(rman) backup in Oracle?

What are the differences between date and timestamp in oracle?

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

How to export data with a field delimiter?

What is Undo Management Advisor in Oracle?

Give the various rollback segment states.

17. Display the order number and average item cost for each order.

For more Oracle General Interview Questions Click Here