DB/Oracle/PLSQL/ȿ

ܼ

ȿ֤LOOPWHILEFOR


LOOP ʸ

ñʤ롼ס

  • LOOP ʸ

WHILE ʸ

äȹʥ롼ס

LOOP ʸƱEXIT ˤ롣ĤޤȤ BREAK

  • WHILE ʸ

FOR ʸ

FOR ˤ롢ѿȤä롼ס

󥯥Ȥ̤ 1 Ǹꡣstep 2 ߤʤȤϤǤʤ

ѿɬפϤʤѤѿƱ̾Υ󥿤ѤϤǤ뤱ɤ⡢Ūˤ̤ѿȤư롣

LOOP ʸ WHILE ʸƱEXIT 롣

  • FOR ʸ

FOR 롼

Ȥ߹碌ȡʣԤθ̤Ф FOR EACH ʸäݤưǤ롣

ܺ٤̥ڡ˵ҡ

롼פΥͥ

ɥͥȤǽ

END LOOP ˥٥ղäȡ¦Υ롼פνλ˳¦Υ롼פ⽪λǤ

  • 롼פΥͥ

å

CONTINUE롼פǽơΥ롼פ򳫻Ϥ롣

LOOP Ǥ⡢WHILE Ǥ⡢FOR ǤȤ롣

  • CONTINUE ʸ

Last-modified: 2011-11-08 () 15:39:52