what is sql optimization

1 Answers   Fidelity,

---

Why join is faster than subquery?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is a temp table?

0 Answers  

---

What are the query optimization techniques?

0 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What are the types of dbms?

0 Answers  

---

What is constant in pl sql?

0 Answers  

---

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

---

When do we create bitmap indexes

2 Answers   CTS,

---

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

0 Answers  

---

What are the types of join in sql?

0 Answers  

---