Oracle - Procedure 문법_FOR_SELECT문

[ Oracle - Procedure 문법_FOR_SELECT문 ]

 

1. 문법 : FOR cur_item IN (select cd, txtn_yn, emp_yn, retro_yn

                                        from py_payitem_code a

                                        where a.idx_id = '2605'

                                        and a.type_cd = '지')

            LOOP

                       v_count := v_count + 1;

                       ............

            END LOOP;