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 the purpose of tables, private synonyms and public synonyms in Oracle?

What is ordinary table in oracle?

What are operators in oracle?

Explain enable novalidate constraint.

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

How to delete an existing row from a table in oracle?

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

What is an Index ? How it is implemented in Oracle Database ?

How to drop an existing view in oracle?

How to select the name of employee who is getting maximum sal with out using subquery

What are privileges and grants?

can anyody please send me the dump for Oracle 10g certifications for DBA path?

For more Oracle General Interview Questions Click Here