Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Uniqe Value in Combination with Dates
Hello
I have the following Problem.
I have a Table with this Content
DNS-Name-------------IP Adress---------------valid from----------------validtill
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.200204.01.2003
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 Received on Tue Oct 01 2002 - 10:43:43 CDT