[DATABASE/ORACLE] DSINTERVAL_UNCONSTRAINED 데이터 타입 사용하기

■ DSINTERVAL_UNCONSTRAINED 데이터 타입을 사용하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SET SERVEROUTPUT ON;

DECLARE
    V_INTERVAL INTERVAL DAY(9) TO SECOND(9);

    FUNCTION GetDoubleInterval(P_INTERVAL IN DSINTERVAL_UNCONSTRAINED) RETURN DSINTERVAL_UNCONSTRAINED
    IS
    BEGIN
        RETURN P_INTERVAL * 2;
    END;
BEGIN
    V_INTERVAL := '100 0:0:0.123456789';

    DBMS_OUTPUT.PUT_LINE(V_INTERVAL);

    DBMS_OUTPUT.PUT_LINE(GetDoubleInterval(V_INTERVAL));
END;

SET SERVEROUTPUT ON;

DECLARE

V_INTERVAL INTERVAL DAY(9) TO SECOND(9);

FUNCTION GetDoubleInterval(P_INTERVAL IN DSINTERVAL_UNCONSTRAINED) RETURN DSINTERVAL_UNCONSTRAINED

BEGIN

RETURN P_INTERVAL * 2;

END;

BEGIN

V_INTERVAL := '100 0:0:0.123456789';

DBMS_OUTPUT.PUT_LINE(V_INTERVAL);

DBMS_OUTPUT.PUT_LINE(GetDoubleInterval(V_INTERVAL));

END;