Skip to content

Instantly share code, notes, and snippets.

@hackvan
Created May 16, 2016 16:49
Show Gist options
  • Save hackvan/01a28a3c6c76e1a678518e41d073c061 to your computer and use it in GitHub Desktop.
Save hackvan/01a28a3c6c76e1a678518e41d073c061 to your computer and use it in GitHub Desktop.
PL/SQL Oracle: Uso de la instrucción "continue" en un ciclo For.
Declare
Cursor cuprincipal Is
Select '1' as Data From dual
Union
Select '2' as Data From dual
Union
Select '3' as Data From dual
Union
Select '4' as Data From dual
Union
Select '5' as Data From dual;
Begin
For cu In cuprincipal Loop
If Mod(cu.data, 2) = 0 Then
Continue;
End If;
dbms_output.put_line(cu.data);
End Loop;
End;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment