About NVL

From: Kanson Ku <u8422021_at_cc.nctu.edu.tw>
Date: Tue, 03 Aug 1999 23:03:57 +0800
Message-ID: <37A704DC.1BB68FB4_at_cc.nctu.edu.tw>

HI ALL [Quoted] [Quoted] 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
                   ^^^^^^^^^^^

[Quoted] 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 Tue Aug 03 1999 - 17:03:57 CEST