Hi,
I need to generate a report using sql query which uses a date column field weekly and monthly. How that can be done using any oracle date function
for eg
select * from T1 a , T2 b
where a.col = b.col
and a.col1 = <Weekly/Monthly>
Col1 is date column so weekly or monthly is decided based on col1 field for e.g. col1 = 10-JUN-15 then it should consider 7 days including 10-JUN-15 , same for monthly