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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unique key with capatilizing

Re: Unique key with capatilizing

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: Fri, 13 Nov 1998 15:20:57 -0000
Message-ID: <72hin0$j6r$1@schbbs.mot.com>


then why not modify the same trigger to query the current dataset and give an error if a 'match' is found?

You will, of course, have to struggle with the mutating table problem first though.

--
Alan D. Mills

Nicolas Bronke wrote in message <72hanj$3vs$1_at_news01.btx.dtag.de>...
>This idea is not bad, but I am looking for a little bit different. With
this
>trigger you only get uppercase entries.
>I would like to have entries with upper/lowercase but not in different type
>cases.
Received on Fri Nov 13 1998 - 09:20:57 CST

Original text of this message

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