select  sum(sm.quantity*pl.price),
        to_char(sale_dat,'mm.yyyy') as datee
  from  salemap sm,
        pricelist pl
  where sm.prod_id = pl.prod_id
    and sm.dat = pl.dat
    and sm.men_pers_code = (
                            select  men_pers_code
                              from  saleman
                              where name = 'name1'
                           )
  group by to_char(sale_dat,'mm.yyyy')
  order by to_date(datee,'mm.yyyy') desc
/

select  sum(sm.quantity*pl.price),
        to_char(trunc(sale_dat,'mm'),'mm.yyyy') as datee
  from  salemap sm,
        pricelist pl
  where sm.prod_id = pl.prod_id
    and sm.dat = pl.dat
    and sm.men_pers_code = (
                            select  men_pers_code
                              from  saleman
                              where name = 'name1'
                           )
  group by trunc(sale_dat,'mm')
  order by trunc(sale_dat,'mm') desc
/