Connecting Tech Pros Worldwide Help | Site Map

New PL/SQL Feature in Oracle 11g: CONTINUE keyword

Newbie
 
Join Date: Jul 2007
Posts: 4
#1: Jul 16 '07
PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional has an excellent PL/SQL example of the PL/SQL continue clause in-action:
begin
for i in 1..3
loop
dbms_output.put_line('i='||to_char(i));
if ( i = 2 )
then
continue;
end if;
dbms_output.put_line('Only if i is not equal to 2′);
end loop;
end;

Any other changes ??
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,504
#2: Jul 17 '07

re: New PL/SQL Feature in Oracle 11g: CONTINUE keyword


Hi
rajanbabu23
welcome to TSDN
and thanx for shairing your knowledge with us here in the forum.

Regards
Debasis
Reply


Similar Oracle Database bytes