■ SUBTYPE ~ IS ~ RANGE문 : 제한된 서브 타입 정의하기

------------------------------------------------------------------------------------------------------------------------

SET SERVEROUTPUT ON;

 

DECLARE

    SUBTYPE POSITIVE IS BINARY_INTEGER RANGE 1..2147483647;

    V_VALUE POSITIVE;

BEGIN

    V_VALUE := 100;

    

    DBMS_OUTPUT.PUT_LINE(V_VALUE);

END;

------------------------------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요