select ename from emp order by ename offset 4 rows fetch next 5

display records from 5 to 9 using rowid or rownum

Question Posted / ramaraju

Answer Posted / ramaraju

select
ename
from
emp
order by ename
offset 4 rows
fetch next 5 rows only;

try this answer oracle 12c introduced offset fetch rows.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is optimistic concurrency control? : Transact sql

544

What is a database trigger?

612

How to return an array from java to pl/sql?

587

Why is normalization important?

536

Does a primary key have to be a number?

518

What is a sql select statement?

562

Mention what does the hierarchical profiler does?

557

How to make a copy values from one column to another in sql?

572

When is the explicit cursor used ?

588

How to select random rows from a table?

518

What is set serveroutput on in pl sql?

565

Is oracle sql free?

536

how to get @@error and @@rowcount at the same time? : Sql dba

525

What are the ddl commands?

533

What view means?

554