Answer / ajit

select decode ( status, 'open', num ) open,
decode ( status, 'close', num ) close
from A;

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

0 Answers   Goldman Sachs,

---

How to change program global area (pga) in oracle?

0 Answers  

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

What is the best way to do multi-row insert in oracle?

0 Answers  

---

what is exact difference between drop and truncate table.

3 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

List the types of joins used in writing subqueries?

0 Answers  

---

What is a recycle bin in oracle?

1 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---