Answer / Himanshu

To implement paging in Oracle, you'll need to handle it in your application logic. Here's an example using two queries:

1. Query for the total number of rows: SELECT COUNT(*) FROM my_table;
2. Query for the actual data, with a LIMIT clause and OFFSET calculated based on the page size and page number.

What is Data Block ?

2 Answers  

---

What is the parameter mode that can be passed to a procedure?

1 Answers  

---

What are the roles of dba?

1 Answers  

---

How to use "while" statements in oracle?

1 Answers  

---

What are the system predefined user roles?

1 Answers  

---

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  

---

What do you mean by group by clause?

1 Answers  

---

How to define default values for formal parameters?

1 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What is the data pump import utility?

1 Answers  

---

What is the relation of a user account and a schema?

1 Answers  

---

What are the limitations of check constraint?

1 Answers  

---