Display the records between two range?
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 |
sql command 2 know current database
Explain an index segment?
How to call a stored function with parameters?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
In the oracle version 9.3.0.5.0, what does each number shows?
How to count groups returned with the group by clause in oracle?
How do you find current date and time in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is an oracle table?
What is a snapshot in oracle database?
When do I need to use a semicolon vs a slash in oracle sql?
Explain what are clusters?