Sunday, 9 June 2013

PL/SQL program to show IF statement

PL\SQL Block:

DECLARE
counter NUMBER := 1;
BEGIN
WHILE (counter < 5) LOOP
IF counter = 2 THEN
GOTO loopindex;
ELSE
dbms_output.put_line('Index ['||counter||'].');
END IF;
      << loopindex >>
IF counter >= 1 THEN
counter := counter + 1;
END IF;
END LOOP;
END;

No comments:

Post a Comment