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 to fetch the row which has the max value for a column?

What is Trigger in Oracle?

Explain the use of record option in exp command.

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

How to drop an existing view in oracle?

material view and view disadvantages?

Explain rename?

What is tns service name?

How to create a table in a specific tablespace?

What do you know about normalization? Explain in detail?

How to convert a string to a date in oracle database?

Why do you create or replace procedures rather that drop and recreate.

For more Oracle General Interview Questions Click Here