From: knijff@bigfoot.com (Ted Knijff)
Newsgroups: comp.databases.oracle.misc
Subject: Re: first trigger, how do I incremement a value?
Date: Sat, 03 Mar 2001 20:14:27 GMT
Organization: 1&1 Internet AG
Lines: 38
Message-ID: <3aa1507b.41304272@news.online.de>
References: <ztbo6.12796$c7.3756633@news3.rdc1.on.home.com>
NNTP-Posting-Host: p3e9ecaf3.dip0.t-ipconnect.de
X-Trace: news.online.de 983650392 21677 62.158.202.243 (3 Mar 2001 20:13:12 GMT)
X-Complaints-To: abuse@online.de
NNTP-Posting-Date: 3 Mar 2001 20:13:12 GMT
X-Newsreader: Forte Free Agent 1.21/32.243


Try :
CREATE OR REPLACE TRIGGER SET_HOLDNR BEFORE
    INSERT ON HOLDING FOR EACH ROW
BEGIN
 UPDATE NMBRHOLDINGS SET <fieldname> = <fieldname> + 1;
END;

I assume that NMBRHOLDINGS is a table, fieldname a field NUMBER type.

And read a manual or the PL/SQL help.

Hth,

Ted
On Sat, 03 Mar 2001 19:19:59 GMT, "MadG" <patrick4133@hotmail.com>
wrote:

>Heya!
>
>It's my first trigger and I need a little help.
>
>I have to   Create a trigger on the HOLDING table that will add 1 to the
>appropriate value in NMBRHOLDINGS when a row is inserted into the HOLDING
>table.
>
>But I don't know how to go about actually adding 1.
>
>All I have seen or can find is comparrisons, nothing with a +,
>
>can someone help me out or post a url that can help?
>
>Thanks in advance.
>
>Patrick.
>
>

EMail: knijff@bigfoot.com