What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

What is query execution plan in sql?

0 Answers  

---

What is a temporal table?

0 Answers  

---

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

---

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 the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

What is tuple in sql?

0 Answers  

---

What is scalar function?

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---

What is pivot query?

0 Answers  

---