Thanks for a quick response. No, I haven't .. this is a complete new learning for me. I shall try...
Is there any easier way ? On Sun, Jan 23, 2011 at 11:13 AM, Javier Montani <jmont...@gmail.com> wrote: > Did you try fetch prior? See > http://starlet.deltatelecom.ru/rdb$doc/oraclerdb/gsp7/gus_pro_list_curs.html > > 2011/1/23 gayathri Dev <gd0...@gmail.com> > >> hope this can give a lil more picture of what I am doing. >> >> I am using Index_by_table (tab_user) of type struct_tab_user >> >> for i in tab_user.first.. tab_user.last loop >> if treat(tab_user(i) as struct_tab_user).user_id = 'user5' then >> next_user_id := tab_user.next(i); *-- returns NULL, but I >> want to loop back and say the next_user is user1* >> next_user := treat(tab_user(next_user_id) as >> struct_tab_user).user_id ; >> end if; >> end loop; >> >> user1, 1 <- Next user >> user2, 2 >> user3, 3 >> user4, 4, >> user5, 5. <- input parameter. >> >> >> >> >> On Sun, Jan 23, 2011 at 10:46 AM, gayathri Dev <gd0...@gmail.com> wrote: >> >>> Hi All, >>> >>> Is there a way to loop back? >>> >>> say if I have a records as below: >>> >>> user1, 1 >>> user2, 2 >>> user3, 3 >>> user4, 4, >>> user5, 5. >>> >>> and my cursor is pointing to user5, and I have to loop back to first >>> record. >>> How can i do that in Oracle10g?? >>> >>> Thanks in advance! >>> G >>> >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to Oracle-PLSQL@googlegroups.com >> To unsubscribe from this group, send email to >> oracle-plsql-unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en >> > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
