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 |
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?
how do you do sql tuning?
How heap is implemented in database?
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 ?
What is the difference between primary and candidate key?
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
What are the most common databases?
What happens when shared and exclusive locks are applied on data item?
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
When should you not use firebase?
What is ole db used for?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)