How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

Why truncate is used in sql?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

What is compilation error in pl sql?

0 Answers  

---

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

What is the largest value that can be stored in a byte data field?

0 Answers  

---

What is bind variable in pl sql?

0 Answers  

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

Can we insert in sql function?

0 Answers  

---

What is nosql db?

0 Answers  

---