Why merge statement is used inside the database?



Why merge statement is used inside the database?..

Answer / Nasir Ikram

The MERGE statement in a database allows for an efficient way to update, insert, or delete rows based on specific conditions. It combines multiple operations like INSERT, UPDATE, and DELETE into a single command, which can help reduce errors and improve performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

3 Answers   CTS,


how do you do sql tuning?

1 Answers   Systel,


How heap is implemented in database?

1 Answers   Amazon,


i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

1 Answers  


What is the difference between primary and candidate key?

1 Answers   BirlaSoft,


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

1 Answers  


What are the most common databases?

1 Answers  


What happens when shared and exclusive locks are applied on data item?

1 Answers  


Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  


can anyone please tell what are the roles and responsibilities of a teradata developer in detail???

1 Answers  


When should you not use firebase?

1 Answers  


What is ole db used for?

1 Answers  


Categories