Defining functional dependency constraints
From: Yash <yash_ganthe_at_hotmail.com>
Date: Tue, 19 Feb 2002 14:23:20 +0530
Message-ID: <a4t3al$b9s$1_at_news.vsnl.net.in>
Hi,
Date: Tue, 19 Feb 2002 14:23:20 +0530
Message-ID: <a4t3al$b9s$1_at_news.vsnl.net.in>
Hi,
I created a table using
[Quoted] [Quoted] create table myTable(id number, name varchar2(20), ind number, cd
varchar2(20)) ;
I made id, the primary key. I want to define a constraint by which for the
same value of ind, the value for cd will be the same. , i.e. ,
1,"hello",5,"Washington"
1,"hi",5,"London"
will be invalid.
In pure database concepts, such a constraint is called a functional
dependency. They write it as ind->cd and read as ind functionally determines
[Quoted] cd. I have not been able to figure out a way to define this constraint in
Oracle.
Any help will be appreciated.
Thanks Received on Tue Feb 19 2002 - 09:53:20 CET