Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger to ensure unique objects
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
![]() |
![]() |