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.

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

---

What is oracle join syntax?

1 Answers  

---

What is Water Mark in Oracle?

7 Answers   Oracle,

---

What is the data pump export utility?

1 Answers  

---

What is Trigger in Oracle?

1 Answers   MCN Solutions,

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

What happens if the update subquery returns multiple rows?

1 Answers  

---

How do we switch from init.ora file to asp file?

2 Answers  

---

20. Using a set operator, display the client number of all clients who have never placed an order.

1 Answers   Wipro,

---

What is oracle used for?

1 Answers  

---

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

---

Select the Nth lowest value from a table?

4 Answers  

---