How to open and close an explicit cursor in oracle?

0 Answers  

---

definition of cluster and non-clustered index?

0 Answers   CSS,

---

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

0 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  

---

What is Parallel Server ?

3 Answers  

---

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

What is Reduced List of Values?

0 Answers   iFlex,

---

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

---

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,

---

Differentiate between pre-select and pre-query?

0 Answers  

---

What is the difference between primary key and unique key and foreign key in oracle?

0 Answers  

---