PL/SQL DECLARE Example

PL/SQL DECLARE 예제

DECLARE
    V_CNT NUMBER := 0;          --변수선언
BEGIN
    DBMS_OUTPUT.ENABLE;     ----DBMS OUTPUT 출력사용
    DBMS_OUTPUT.PUT_LINE('--------------------------------------------------');
    SELECT
        COUNT(*)
    INTO V_CNT          --변수값
    FROM TABLE_NAME;
   
    DBMS_OUTPUT.PUT_LINE('V_CNT :' || V_CNT);       --DBMS OUTPUT 출력

END;

결과 ( 토드[TOAD] > VIEW > DBMS OUTPUT )