Stuff

select sum(amount)
from feiten, dimensie_dates
where feiten.date_key = dimensie_dates.date_key
and feiten.date_key = to_date('15-03-2011','ddmmyyyy')