Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger to ensure unique objects

Re: Trigger to ensure unique objects

From: Christian \ <Christian.Gulich_at_IN.Stud.TU-Ilmenau.de>
Date: Tue, 20 Jan 2004 16:50:27 +0100
Message-ID: <bujikt$rs5$1@piggy.rz.tu-ilmenau.de>


Hi,
'uniqueness' is determined by some attributes extracted from an image, not only the filename or an other simple attribute. But I found a solution in using "instead of"-triggers. There aren't any locks, wich disturb my trigger.
Christian

>
> What determines 'uniqueness' here though?
>
> eg If you open a word document, change a letter and change it back, then
> save it, the binary result is not the same as the original document.
> Various attributes (file name, modified, size, etc) might be candidates
> for uniqueness but these could be done as separate scalar datatypes and
> thus the standard uniqueness constraints used.
>
> hth
> connor
> --
> -------------------------------
> Connor McDonald
> http://www.oracledba.co.uk
> Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"
>
Received on Tue Jan 20 2004 - 09:50:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US