Answer / abc

Select * from user_sys_privs;

How to download oracle database 10g xe?

0 Answers  

---

What is the exact use of Collections?

0 Answers  

---

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

---

What is the difference between post-database commit and post-form commit?

0 Answers  

---

What is Hash Index?

1 Answers  

---

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

0 Answers  

---

What is an anonymous block?

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  

---

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

2 Answers  

---

How to concatenate two text values in oracle?

0 Answers  

---

defination of bitmap index

0 Answers   NIIT,

---

what is the syntax of DELETE command?

8 Answers  

---