Conrol Statement (IF, CASE, LOOP, FOR, ...)
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/controlstatements.htm#LNPLS004
Conditional selection statements, which run different statements for different data values.
The conditional selection statements are
IF
and andCASE
.Loop statements, which run the same statements with a series of different data values.
The loop statements are the basic
LOOP
,FOR
LOOP
, andWHILE
LOOP
.The
EXIT
statement transfers control to the end of a loop. TheCONTINUE
statement exits the current iteration of a loop and transfers control to the next iteration. BothEXIT
andCONTINUE
have an optionalWHEN
clause, where you can specify a condition.Sequential control statements, which are not crucial to PL/SQL programming.
The sequential control statements are
GOTO
, which goes to a specified statement, andNULL
, which does nothing.
'DB > Oracle' 카테고리의 다른 글
Sequence로 동일 데이터 insert (0) | 2016.05.09 |
---|---|
SQL BATCH 속도 (0) | 2015.10.20 |
최근 날짜의 id 레코드만 남기고 중복 제거하기 (0) | 2015.08.26 |
[oracle] import from text file (0) | 2015.08.24 |