Answer / phanikumar

to retrieve all the record at a time we use BULK COLLECT

but in cursors records will be retrieved one by one in loop. cursors an time taking process .

How will you a activate/deactivate integrity constraints?

2 Answers  

---

Who is the owner of mysql database?

0 Answers  

---

What is sharding in sql?

0 Answers  

---

What is the non-clustered index in sql?

0 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---

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 NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

How do I count rows in sql?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

What is varchar sql?

0 Answers  

---

How can I see all tables in sql?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---