select rownum, empno, ename from emp where rowid in (select rowid from emp

Display the records between two range?

Question Posted / nishi

Answer Posted / nishi

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to set a transaction to be read only in oracle?

1030

What is oracle join syntax?

940

How to manage transaction isolation level?

948

How to convert dates to characters in oracle?

979

How to define a data source name (dsn) in odbc manager?

964

What are the four Oracle system processes that must always be up and running for the database to be useable?

953

interview questions with answer for cts

2531

Explain the use of compress option in exp command.

963

Please explain oracle data types with examples?

989

How to get the Installed Oracle Version Information ?

1072

How many types of segments in Oracle?

1011

What is an oracle database?

983

How does oracle handle read consistency?

1049

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1286

What do you mean by a tablespace?

980