Display the records between two range?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by cdb and pdb in oracle 12c?

641


What happens to the current transaction if a ddl statement is executed?

580


What are the benefits of ordbms?

623


What is BBED in Oracle?

690


What is merge statement used for?

574






Which environment variables are absolutely critical in order to run the OUI?

1664


What is tns name?

548


What is a nested table and how is it different from a normal table?

585


How to work with data objects interactively?

559


How to use subqueries in the from clause in oracle?

584


How to drop an existing table in oracle?

597


How to load a large xml file?

587


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1698


How many categories of data types in oracle?

607


Explain cascading triggers.

576