hi,
i have two tables:
table1: mid,name [ here, mid is the primary key ]
table2: mid,did,location [ here, mid&did is the composite primary key
also, mid references mid in table1 ]
now, i need to increment [did] against a particular mid value....
how can that be done?
please help.
i have created my tables this way....is this correct?
T1: create table t1(mid number(2) primary key, name varchar2(20));
T2: create table t2(mid number(12),did number(3),location varchar2(1000) not null, PRIMARY KEY(mid,did),
constraint me_id foreign key(mid) references t1(mid));
please help.