Reply-To: "MadG" <patrick4133@hotmail.com>
From: "MadG" <patrick4133@hotmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: first trigger, how do I incremement a value?
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <ztbo6.12796$c7.3756633@news3.rdc1.on.home.com>
Date: Sat, 03 Mar 2001 19:19:59 GMT
NNTP-Posting-Host: 24.112.214.137
X-Complaints-To: abuse@home.net
X-Trace: news3.rdc1.on.home.com 983647199 24.112.214.137 (Sat, 03 Mar 2001 11:19:59 PST)
NNTP-Posting-Date: Sat, 03 Mar 2001 11:19:59 PST
Organization: Excite@Home - The Leader in Broadband http://home.com/faster


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.