I have requirement like,
select *from table
where col between 01-JAN-17 and 31-DEC-17
for that i need pass a parameter for daterange like 01-JAN-17 to 31-DEC-17
how can we take single parameter for date range?
or is there any alternative way to pass parameter?
Please help us any one if know the solution . thanks.