CREATE OR REPLACE FUNCTION compareTime (
v_beginToc date,
v_endToc date,
v_begin date,
v_end date
)
RETURN NUMBER
AS
v_result NUMBER(1):=0;
BEGIN
IF (v_beginToc BETWEEN v_begin AND v_end) OR (v_endToc BETWEEN v_begin AND v_end) THEN
v_result := 1;
ELSIF (v_begin BETWEEN v_beginToc AND v_endToc) OR (v_end BETWEEN v_beginToc AND v_endToc) THEN
v_result := 1;
END IF;
RETURN v_result;
END;