Interested to Buy Any Domain ? << Click Here >> for more details...
Display the records between two range?
- 2 Answers
- 3645 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / basanti
select * from emp where emp_id between '200' and '300'
| Is This Answer Correct ? | 0 Yes | 0 No |
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to pass a cursor variable to a procedure?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is clustered table in Oracle?
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 the difference between formal parameters and actual parameters?
List the various oracle database objects?
How to work with data objects interactively?
How to create a table interactively?
8. Display the client name and order date for all orders using the natural join keywords.
What are the different pseudo commands? Explain in general?
What is an Oracle index?
Oracle General 
