this is my select stmt in cursor... i wrote this stmt in xml formate... so here i want to do paging....
here i am unable to do paging can anyone help me please
my paging is..
WHERE ROWNUM < (( l_pageNumber*l_pageSize) + 1)
WHERE RN >= (((l_pageNumber-1)* l_pageSize)+1) ;
but here i wrote in xml....