Hi all,Could anyone let me know the equivalent code in pl/sql for this java code? I really appreciate that.for (int i = 0; i < 10; i++) {if (i == 5){continue;}} thanks,kamalnayan.M

Interview Candidate
Jun 28th, 2006
8
2138

Showing Answers 1 - 8 of 8 Answers

vijaya

Jul 6th, 2006

select *
from a
where i=(select i from a
where i<10) and i=5;

amit

Jul 10th, 2006

DECLARE
I   INTEGER(2);
BEGIN
FOR I = 0..10 LOOP
     ...
     IF I = 5 THEN
         EXIT;
     END IF
END

Ray

Jul 12th, 2006

BEGIN
FOR i in 0 .. 9 LOOP
    IF i = 5 THEN
      EXIT;
    END;
END LOOP;
END;

ganne

Aug 1st, 2006

begin
for i in 1..10 loop
if i=5 then
update emp set sal=sal+100;
end if;
end loop;
end;

Rama Krishna.Y

Aug 9th, 2006

Hi Kamal!!
This may help you...
for i in 0..9 loop
if i=5 then
break;
end if;
end loop;
Thanks&Regds
Ramki,TCS,Hyd

Murali

Sep 25th, 2006

Hi, This can be done in this way also...
as there is no equivalent keyword called "break" or "continue"..instead we can write it in other fashion...here it goes
begin
for i in 1..10 loop
if i=5 then
NULL; //do nothing(continues the loop without exiting from the for loop)
end if;
end loop;
end;
this will definitely work....:-)

madhu

Feb 9th, 2007

I hope this will work..
declare
i number(2);
Begin
for i in 1.. 10
loop
if (i ==5) then

else
exit;
end loop;
end;

ravikumarzee@gmail.com
Profile Answers by ravikumarzee@gmail.com Questions by ravikumarzee@gmail.com

Mar 8th, 2007

begin

for i in 1..10 loop
if i <> 5 then
-- do stuff.
end if;
end loop