create or replace FUNCTION  getValoare(
id in int,what in VARCHAR)
return float
AS
last_value float;
BEGIN
if phanalyse(id)=0 then return 0;
end if;
if what='Magneziu' then
select Magneziu into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;
ELSIF what='Calciu' then
select Calciu into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Colesterol' then
select Colesterol into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Sodiu' then
select Sodiu into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Trigliceridele' then
select Trigliceridele into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Glicemia' then
select Glicemia into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Trombocite' then
select Trombocite into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Leucocite' then
select Leucocite into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;

ELSIF what='Hematii' then
select Hematii into last_value from (select * from analize where ID_PACIENT=id ORDER BY ID_ANALIZA DESC) where rownum<2;


END IF;

 return last_value;
END getValoare;