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
What do you mean by cdb and pdb in oracle 12c?
What happens to the current transaction if a ddl statement is executed?
What are the benefits of ordbms?
What is BBED in Oracle?
What is merge statement used for?
Which environment variables are absolutely critical in order to run the OUI?
What is tns name?
What is a nested table and how is it different from a normal table?
How to work with data objects interactively?
How to use subqueries in the from clause in oracle?
How to drop an existing table in oracle?
How to load a large xml file?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How many categories of data types in oracle?
Explain cascading triggers.