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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Functional Dependency to constrain a relation to exactly one element?

Re: Functional Dependency to constrain a relation to exactly one element?

From: Alfredo Novoa <alfredono_at_gmail.com>
Date: 2 Oct 2006 04:41:32 -0700
Message-ID: <1159789292.329276.17910@h48g2000cwc.googlegroups.com>

Marshall wrote:

> If it can't be done with an FD, can we do it with a constraint?
> Trivially we can do it with an aggregate constraint:
>
> constraint(R.count() == 1)
>
> but I'm curious if such a thing can be done without reference
> to an aggregate function.

var R { ... } key { };

Regards
  Alfredo Received on Mon Oct 02 2006 - 06:41:32 CDT

Original text of this message

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