Answer / Rajnesh Kumar

The main join types in T-SQL include INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN.

What is the difference between Union and Union all. Which is faster.

1 Answers  

---

How to call shell script from pl sql procedure?

1 Answers  

---

What is a dynamic query?

1 Answers  

---

what is collation? : Sql dba

0 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

What is serial sql?

1 Answers  

---

How can we store rows in PL/SQL using array?

1 Answers   MCN Solutions,

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1 Answers  

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

What are the Restrictions on Cursor Variables?

2 Answers  

---