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
How to use windows user to connect to the server?
Can we insert data in view oracle?
Explain parameter file in oracle.
How to name query output columns in oracle?
What is clustered table in Oracle?
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.
What do you understand by a database object?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How do we display rows from the table without duplicates?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is a trigger and what are its types in oracle?
How to use an explicit cursor without open statements?
State and explain the different types of data models?
Explain integrity constraints?
What is Data Dictionary Cache in Oracle?