Solved

ADD 5  TO COUNTER IN FOR LOOP

Posted on 2008-10-01
4
1,121 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 74

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 74

Expert Comment

by:sdstuber
ID: 22636245
glad I could help
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

726 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