sql - Next 30 days from a current date -

i have procedure seelcting employers , few datails them. need select ones hired in next 30 days day given parameter.

my parameter defined here:

create or replace procedure procedure_emp(p_day in emp.hiredate%type)

when execute procedure i'm doing procedure_emp('17-dec-80');

in procedure declaration right have:

where p_day = emp.hiredate;

here need write calculate next 30 days. i'm not familiar working dates, please give me pice of advice.

assuming want select employees hiredate between p_day , following 30 days, want:

where emp.hiredate between p_day , p_day + 30

in oracle, if have date-variable (or date constant, matter) can add days + <number> operator.

Two