Solved

ADD 5  TO COUNTER IN FOR LOOP

Posted on 2008-10-01
4
1,099 Views
Last Modified: 2013-12-19
How can I increment  the count in a variable in the loop instead of codeing the actual numbers for the count such as (4,9,14,19,24).  In other words, I just want to add 5 to the counter beginning with record number 4 in the loop.  There can be up to 24  records in the loop.    

This is an oracle table.  I'm using PL/SQL.
See attached code.  



v_count := 0
 

for c1 rec in c1  loop

 v_count := v_count + 1;
 

if v_count in (4,9,14,19,24)  then 

  put_line (l_file,'TEST1');

end if;

 if v_count  in (5,10,15,20) then

  put_line(l_file,TEST2);

end if;

if v_count in (6,11,16,21)

 put_line(l_file,TEST2);

end if;
 

end loop;

Open in new window

0
Comment
Question by:ratliffjm
  • 2
  • 2
4 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 125 total points
ID: 22620019
use the "mod" function to do your "loop" check and since you only care about values 4 or higher, then simply wrap all of the conditions in that.
v_count := 0

 

for c1 rec in c1  loop

 v_count := v_count + 1;

 

  if v_count >= 4 then

    if mod(v_count,5) = 4 then  

       put_line (l_file,'TEST1');

    end if;

    if mod(v_count,5) = 0 then

       put_line(l_file,TEST2);

    end if;

    if mod(v_count,5) = 1 

       put_line(l_file,TEST2);

    end if;

  end if;

end loop;

Open in new window

0
 

Author Comment

by:ratliffjm
ID: 22620061
Thanks.   I will test the code when I'm at the office tomorrow morning.
0
 

Author Closing Comment

by:ratliffjm
ID: 31502205
Thanks
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 22636245
glad I could help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now