Display the records between two range?
- 2 Answers
- 2870 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 what are the uses of rollback segment?
How do you rate yourself in oracle and sql server ?
What is ASM (Automatic Storage Management) in Oracle?
State some uses of redo log files?
How to convert numbers to characters in oracle?
How can we find out the current date and time in oracle?
How to delete a column in an existing table in oracle?
Explain what are the different type of segments?
How to change program global area (pga) in oracle?
Explain integrity constraint?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Oracle General 
