How do I tune a sql query?

0 Answers  

---

how to calculate expressions with sql statements? : Sql dba

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

what is inline command?

2 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,

---

Which is better cte or subquery?

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

What is a call statement? Explain with an example.

0 Answers  

---

how can i create a user defined datatype

3 Answers  

---

What are the ddl commands?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---