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@news.vsnl.net.in>

Hi,

I created a table using
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 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 - 02:53:20 CST