Re: Uniqe Value in Combination with Dates

Sascha Kern wrote:

> Hello
>
> I have the following Problem.
> I have a Table with this Content
> DNS-Name-------------IP Adress---------------valid from----------------valid
> till
> .
> Server1 128.6.4.2 05.10.2002
> 15.10.2002
> Server2 61.4.48.18 01.01.2001
> 31.12.2001
> Router1 161.4.48.18 01.01.2002
> 06.12.2003
> Router2 128.6.4.2 20.11.2002
> 04.01.2003
> .
> .
> and so on
>
> I have to insure, if i add or modify a record, that there ist no collision
> with existing dates.
> I think this con only be done with an insert / Update Trigger.
> Can someone please explain how such a Trigger looks like.
>
> Thanks
>
> Sascha Kern

Go to http://tahiti.oracle.com and search for "BEFORE INSERT TRIGGER".

You will find plenty of good material to work with.

After you have made an attempt at writing your own trigger, if you are having problems with the code ... post your work as well as the version of Oracle in which you are working.

Daniel Morgan Received on Tue Oct 01 2002 - 11:04:36 CDT