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 collections are improve the performance?

1 Answers   Polaris,

---

what is difference between decode and case function?

2 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

How to use sql statements in pl/sql?

0 Answers  

---

What are different types of sql?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

What is ON DELETE CASCADE?

3 Answers  

---

What is pivot in sql?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

How to rename a table?

0 Answers  

---

What is the difference between clustered and non-clustered index in sql?

0 Answers  

---