curiousperson
asked on
How to create a function that checks dates using a boolean value
I need to create a function that will:
1) return a Boolean true/false.
2) the function should receive a slip_num, arrive_date, depart_date as parameters.
3) if the slip is available during the duration of the arrive date to depart date, the function
should return true. Otherwise it should return false.
1) return a Boolean true/false.
2) the function should receive a slip_num, arrive_date, depart_date as parameters.
3) if the slip is available during the duration of the arrive date to depart date, the function
should return true. Otherwise it should return false.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
in our company we use it the recognize variables in the source
i keep the habit (partially) on expert_exchange
otherwise a shoud have defined also
create or replace function slip_available(p_slip_num number, p_arrive_date date, p_depart_date) return
where p_ refers to parameters (= arguments)
otherwise a shoud have defined also
create or replace function slip_available(p_slip_num number, p_arrive_date date, p_depart_date) return
where p_ refers to parameters (= arguments)
ASKER