Not really a quaestion...but i need help
        Posted  
        
            by Dan F.
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Dan F.
        
        
        
        Published on 2010-05-24T19:48:26Z
        Indexed on 
            2010/05/24
            19:51 UTC
        
        
        Read the original article
        Hit count: 165
        
I have to make a process in Oracle/PLSQL.....i have to verify that the interval of time between start_date and end_date from a new row that i create must not intersect other start_dates and end_dates from other rows. Now I need to check each row for that condition and if it doesn't correspond the repetitive instruction should stop and after that to display a message such as "The interval of time given is not correct".
I don't know how to make repetitive instructions in Oracle/PLSQL and I would appreciate if you would help me.
© Stack Overflow or respective owner