농부지기

[ Oracle - Procedure 문법_DBMS_OUTPUT ]

1. SET SERVEROUTPUT ON ;    -- DBMS 출력하기 위해서~~

   (or set serveroutput on size 1000000;)

   1.1 procedure 실행하기 전에 먼저 위 명령어 실행

   1.2 pl/sql 문장내 맨위에  [DBMS_OUTPUT.ENABLE;] 도 해줘야 한다.

   1.3 DBMS_OUTPUT.PUT_LINE( '사원번호 : ' || v_emp.empno );

WHILE문

1. 형식

WHILE condition LOOP

statement;

...

END LOOP;

2. 예제

  ex) ...

          v_ord_id s_item.ord_id%TYPE := 101;

          v_counter NUMBER(2) := 1;

        BEGIN

          ...

        WHILE v-counter <= 10 LOOP

            INSERT INTO s_item (ord_id, item_id)

            VALUES (v_ord_id, v_counter);

                          v_counter := v_counter + 1;

        END LOOP;

          ...

[ Oracle - Procedure 문법_LOOP문 ]

1. 문법

LOOP

statement;

...

EXIT [WHEN condition];

END LOOP;

2.예제

   ex) ...

          v_ord_id s_item.ord_id%TYPE := 101;

          v_counter NUMBER(2) := 1;

        BEGIN

          ...

        LOOP

          INSERT INTO s_item (ord_id, item_id)

          VALUES (v_ord_id, v_counter);

                        v_counter := v_counter + 1;

        EXIT WHEN v_counter > 10;

        END LOOP;

         ...