Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Display the records between two range?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use windows user to connect to the server?

957


Can we insert data in view oracle?

981


Explain parameter file in oracle.

987


How to name query output columns in oracle?

1149


What is clustered table in Oracle?

1138


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1307


What do you understand by a database object?

1005


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1911


How do we display rows from the table without duplicates?

943


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2222


What is a trigger and what are its types in oracle?

1026


How to use an explicit cursor without open statements?

1026


State and explain the different types of data models?

912


Explain integrity constraints?

1076


What is Data Dictionary Cache in Oracle?

1132