Re: About NVL

In article <37A704DC.1BB68FB4_at_cc.nctu.edu.tw>, u8422021_at_cc.nctu.edu.tw says...
> 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
>
>
NVl returns Y_value if X_value is null otherwise it returns X_value.

In other words if the value returned for Sequence is blank or null it will be replaced with 0. Received on Tue Aug 03 1999 - 17:32:10 CEST