paging

[13579]

I have a Search field . When user enters a
value in the Search field, I want to display the first 10 rows
which match the query, then the next 10..and so on.
but problem is i use cursor inside the select statement.because i use nested table.
this is the query

select t.empid,t.empname,cursor( select a.st,a.city from TABLE(t.address) a)
from emp t

here i cann't get the result when using the page thing as follows
select *
from (select b.*,rownum r
from (select t.empid,t.empname,cursor( select a.st,a.city from TABLE(t.address) a)
from emp t
order by t.empid) b)
where r between 1 and 3

 

[MikeLacey]

Mike Jones answered your previous thread on this question:

Have a look at thread186-92548 Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.