OraFAQ Forum: SQL & PL/SQL » how to retrieve only rows X to Y from view

Home » SQL & PL/SQL » SQL & PL/SQL » how to retrieve only rows X to Y from view

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to retrieve only rows X to Y from view [message #19590]

Sat, 30 March 2002 20:27

Malla Reddy
Messages: 1
Registered: March 2002

Junior Member

Hi

i want to display 10 records at a time.
i'm using oracle view. how to fetch set of 10 records followed by next set of 10 records, i've 1000 records
so first i've to dsiplay first 10 records in first page after that next 10 records in next page and so on

Thanks in advance

Malla Reddy

Report message to a moderator

Re: how to retrieve only rows X to Y from view [message #19594 is a reply to message #19590]

Sun, 31 March 2002 22:58

Nilesh Mahajan
Messages: 10
Registered: March 2002

Junior Member

select col1 from tab1 where rownum <=x
minus
select col1 from tab1 where rownum < y

will give you records between rownum x and y
or use cursors.

Report message to a moderator

Re: how to retrieve only rows X to Y from view [message #19628 is a reply to message #19594]

Mon, 01 April 2002 23:25

hanu
Messages: 21
Registered: March 2002

Junior Member

set pause on
set pagesize 10

If you excute the above two lines of code before
select statement that may meet your requirements.

Report message to a moderator

Previous Topic:	Re: Need SQL for Deleting Tree Data
Next Topic:	How to find out which database I am using from the SQL Promt??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 17 12:41:50 CDT 2025