I have the following code...Im trying to mimic how a .NET program is running their logic in SQL Developer
SO I have a loop with a Select statement and the next line of code is a call to a procedure that does another Select statement in a loop so my question is...
for i in(Select * from INSURED_ENTITY where CVG_ID= l_Temp_COV_cvg_ID AND POLNBR= l_Temp_COV_polNbr AND COV_EFFDT = l_Temp_COV_covEffDate ORDER BY COV_NAME_SEQ ASC) loop
For j in(Select * from ENDORSE Where NAME_OF_CLIENT = i.NAME) LOOP
How do I iterate through these for loops? If I wanted to do a Next I or a Next j how could I do that? Is there a list of properties or methods that I can check? Like how do I check for end of the data set? I know I can access the I loop fields like i.NAME but what are my other options with the for loop for i? Can I check rowcount or anything?