Re: About NVL
Date: Wed, 04 Aug 1999 11:28:38 +0900
Message-ID: <37A7A556.656CBE90_at_jis.ne.jp>
The meaning of
> Select NVL(Sequence,0) + 1
> ^^^^^^^^^^^
> INTO :Production.No
> FROM Seq_number;
is
if (<Seq_number.Sequence> is null) then
Production.No = 1;
else
Production.No = <Seq_number.Sequence> + 1;
end if;
Haiyuan Dong
Kanson Ku wrote:
>
> HI ALL
>
> Is there anyone can tell me about the format of NVL
> I find the document in the Oracle and form etc...
> but still can not know the meaning about it
>
> In PL/SQL
> PRE_INSERT trigger
>
> Select NVL(Sequence,0) + 1
> ^^^^^^^^^^^
> INTO :Production.No
> FROM Seq_number;
>
> what is the meaning about the schema Sequence and the number 0 ?
>
> thx in advance
>
> Kanson
> u8422021_at_cc.nctu.edu.tw
Received on Wed Aug 04 1999 - 04:28:38 CEST