Interested to Buy Any Domain ? << Click Here >> for more details...
Display the records between two range?
- 2 Answers
- 3528 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 |
What the is the diff between local index and global index. give some example.
what are different types of deletes?
Explain can a view based on another view?
How to use an explicit cursor without open statements?
How to view the tablespaces in the current database?
What is Data Block ?
Difference between the “verify” and “feedback” command?
who is the father of oracle and send chodd rules
What is flashback in Oracle?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
What is ceil and floor in oracle?
What do you mean by cdb and pdb in oracle 12c?
Oracle General 
