Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

Is pl sql still used?

0 Answers  

---

Is left join faster than join?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

What is coalesce in sql?

0 Answers  

---

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

How do I find duplicates in two columns?

0 Answers  

---

Enlist the advantages of sql.

0 Answers  

---

Can we use delete in merge statement?

0 Answers  

---

Compare sql & pl/sql

0 Answers  

---