Oracle-L: RE: Question about Constraint

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Fri, 29 Aug 2003 02:19:26 -0800
Message-ID: <F001.005CDF23.20030829021926@fatcity.com>

I think the only way to do this is by using a (before insert) trigger.

Jack

-----Original Message-----
Sent: Friday, August 29, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L

Hallo,

I would like to gets ome help on this:

I have this table

Id Companynumber First Name LastName Type

1     123               Jim         Andersson   1
2     234               Tom         Perkins           2
3     565               Henry       Ford        1

I would like to have a constraint so when I try to add and the same companynumber that already exists(for instance 234) I am not allowed to do this if the filed Type has the value 1. So if I add a companynumber which already exists and the Type is 2, then I should be allowed to add this companynumber.

Maybe this is simple but woul dreally appreciate some help onhow to write this.

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: roland.skoldblom_at_ica.se

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jack van Zanen
INET: JACK_at_QUANTSYSTEMS.NL

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------