Re: ORACLE DEVELOPER
From: Ivar Stolfot <Ivar.Stolfot_at_mail.ee>
Date: Wed, 29 Nov 2000 16:17:06 +0200
Message-ID: <3a250fec$0$28896_at_diablo.uninet.ee>
Date: Wed, 29 Nov 2000 16:17:06 +0200
Message-ID: <3a250fec$0$28896_at_diablo.uninet.ee>
.. and optimized version ..
create or replace function percent(per number)
RETURN NUMBER IS
BEGIN
RETURN NVL(per,0)/100;
END percent;
"Dejan Ilijic" <dejan_at_infolink.hr> wrote in message
news:3A24F559.34E82E1A_at_infolink.hr...
>
>
> Dejan Ilijic wrote:
>
> > create or replace function percent(per number)
> > RETURN NUMBER IS
> > perr NUMBER;
> > P1 NUMBER:=NVL(per,0);
> > BEGIN
> > perr:=P1/100;
> > RETURN perr;
> > END percent;
>
> this is valid function :))
> BYE..
>
>
Received on Wed Nov 29 2000 - 15:17:06 CET