In sequence i want to 11 and 15th values how we will write?



In sequence i want to 11 and 15th values how we will write?..

Answer / Nitin Gupta

To retrieve the 11th and 15th values from a sequential data set in Oracle, you can use SQL's row_number() function. Here's an example:

```sql
SELECT * FROM your_table
ORDER BY column_name
OFFSET (10-1) ROWS FETCH NEXT 2 ROWS ONLY;
```
In this example, replace 'your_table' with the name of your table and 'column_name' with the name of the column containing the sequential data. This query will return the 11th and 15th rows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is trace file? what is the use of that?

4 Answers  


what is the defference between credit memo and debit memo

2 Answers  


What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,


How to develop XML report without rdf?

4 Answers   Oracle,


what is fiscalcalendar?

3 Answers   CTS,


what is tuning in oracle apps technical

3 Answers   TCS,


Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,


can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,


what is difference between po_headers_all and po_headers

2 Answers   NTT Data,


explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,


is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,


What is a value set? List its various types.

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)