Answer / Naman Agarwal

The MERGE statement is a powerful SQL command used for updating, inserting, and deleting data in a target table based on the contents of a source table. The main uses of the MERGE statement include:n
1. Efficiently updating large amounts of data.
2. Updating related tables simultaneously.
3. Handling situations where some rows need to be updated, inserted or deleted using different conditions.

give the syntax of grant and revoke commands? : Sql dba

1 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

1 Answers  

---

What is procedure and function in sql?

1 Answers  

---

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 Answers  

---

Why do we use sqlite?

1 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

What are the most important characteristics of pl/sql?

1 Answers  

---

How is debugging done?

1 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---