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 |
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
State the difference between a primary key and foreign key?
Explain view?
What is a View ?
Does oracle charge for java?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are synonyms used for ?
Why do we need oracle client?
which is the best training centre for learning oracle?
How to retrieve first and last records from a table?
various types of joins
what is the syntax of CREATE command?