Hi Experts,
I have requirement to join parameterized view with other views (not parameterized) . for that I have created parameterized view(buss_day_clndr) when I query this view alone with below sql it works fine.
select count(clndr_dt) from buss_day_clndr where st_date = to_date('MM/dd/yyyy', '01/01/2017') and e_date=to_date('MM/dd/yyyy', '12/10/2017')
and below also works fine if parameter values are hard coded and with other tables:
select tb1.col1,tb2.col1,cc.count from table1 tb1 join table2 tb2 on tb1.tb_id=tb2.tb1_id left join buss_day_clndr cc on cc. st_date =to_date('MM/dd/yyyy', '01/01/2017') and cc. e_date = to_date('MM/dd/yyyy', '12/10/2017')
When I replaced hard coded parameter values with dynamic column it is showing null, can you pls help ?
select tb1.col1,tb2.col1,cc.count from table1 tb1 join table2 tb2 on tb1.tb_id=tb2.tb1_id left join buss_day_clndr cc on cc. st_date = tb1.created_dt and cc. e_date = tb1.updated_dt
thanks!
