Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

Does inner join remove duplicates?

0 Answers  

---

Is left join and outer join same?

0 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

What is sql partition?

0 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

What is application trigger?

0 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

Explain spool.

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  

---