Re: need help for triggers

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Tue, 23 Feb 1999 13:57:13 +0100
Message-ID: <7au8r7$gn3$1@readme.online.no>

Venkat Mundrathi wrote in message <7as4ug$pal$1_at_news1.fast.net>...
>I am new to oracle(triggers). I am using personal oracle 8.0,
>
>1)The purpose of trigger is when ever I insert a new row in the emp
>table(hope you know the description) with the same empno or ename it has to
>fire and give an error message to user that the row with empno or ename is
>already exist.

I suggest you define a primary or unique key instead. This is exactly what they're there for.

HTH, Roy Brokvam
roy.brokvam_at_conax.com Received on Tue Feb 23 1999 - 06:57:13 CST