Interested to Buy Any Domain ? << Click Here >> for more details...
Display the records between two range?
- 2 Answers
- 3718 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 |
Explain mutating triggers.
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What are the predefined tablespaces in a database?
What is oracle latest version?
How to write a query with a left outer join in oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to drop an index?
What are the different approaches used by Optimizer in choosing an execution plan ?
Can you drop an index associated with a unique or primary key constraint?
How to start an oracle instance?
What is the difference between PFILE and SPFILE in Oracle?
What is dual table oracle?
Oracle General 
