Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Unhappy Unanswered: Cursor inside a Cursor

    Hi folks,

    I ve recently migrated from Sql Server to oracle.

    My Doubt is ,
    Whether it is possible to open declare , open,close and remove a cursor inside the loop of another cursor which is open .

    If possible just key in simple eg for the syntax....


    Thanx & Regs

    Sreeraj
    Sree

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    you can, it's just
    PHP Code:
    for rec1 in (select value from tableloop
        
    do stuff
        
    for rec2 in (select more_values from another_tableloop
            
    do more stuff
        end loop
    ;
    end loop
    There are 10 types of people in the world, those that know Binary and those that don't.

  3. #3
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Talking Cursor in Cursor

    Hi Robert,

    Thanx buddy..........
    that was coool......


    Thanx and regards once more
    Sree

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •