ACS3 Data Model

     1: function one_if_within_n_days (query_date IN date, n_days IN integer)
     2: return integer
     3: is
     4: begin
     5:   IF (sysdate - query_date) <= n_days THEN
     6:     return 1;
     7:   ELSE
     8:     return 0;
     9:   END IF;
    10: end one_if_within_n_days;