1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Multiple cursor with date handling issue reg

Discussion in 'SQL PL/SQL' started by trungdien, Aug 12, 2017.

  1. trungdien

    trungdien Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    usa
    Dear all,
    i am using three cursors in one pl/sql block each of this three cursor will fetch data based on column of date data type.i believe due to each condition relate to same table,contradiction may arise i.e

    1> when code will execute , cursor c1 will do the job perfectly but c2 & c3 here may not be able to solve the purpose since the job has already been done by cursor c1 which i am not sure.my doubts i need all cursor to work based on each condition.
    any suggestion from your side could sort out this issues.

    Thanks n regards
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,496
    Likes Received:
    356
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Since you have posted no code no one can answer your question. Post the code you are referencing and possibly someone can provide a usable response.