Answer / Vishal Rastogi

In SQL, SIGN() is a function that returns the sign of a numeric value. It returns 1 for positive values, -1 for negative values, and 0 for zero.

how do you tune the slow running queries in oracle db , explain the methodology

1 Answers  

---

What does the hierarchical profiler does?

1 Answers  

---

Mention what pl/sql package consists of?

1 Answers  

---

Can unique keys be null?

1 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

Can there be more than one function with a similar name in a pl/sql block?

1 Answers  

---

Why should I use postgresql?

1 Answers  

---

How to pronounce postgresql?

1 Answers  

---

What problem one might face while writing log information to a data-base table in pl/sql?

1 Answers  

---

What is cursor explain with example?

1 Answers  

---

Which is faster subquery or join?

1 Answers  

---

What are the differences between implicit and explicit cursors?

1 Answers  

---