Fonction & Result Set

create or replace function milan/fmr040 (p_mois dec(2))
returns table (mois dec(2), code dec(8), codcli char(8))
specific milan/fmr040
return select t1.mois, t1.code, t2.codcli
  from
       fmr015p as t0 join fichier2 as t2 on t0.codcli = t2.codcli 
        join fichier1 as t1 on t2.code = t1.code
  where t1.mois = p_mois
  order by t0.codcli, t2.code;

select * from table (fmr040(7)) as t1 order by codcli;