subject:"RE\: Unique value"

Re: Unique value

2002-09-02 Thread Stephane Faroult

sultan wrote: Hi friends, I have a tables A and B DESC A IDNUMBER NAME VARHAR2(10) DESC B --- ID NUMBER SUBNAMEVARCHAR2(20); In the above table B.ID is the foreign key to A.ID. How can I create unique value

RE: Unique value

2002-09-02 Thread Abdul Aleem

in table B In that case you need to define your Primary Key on ID and Sub-Name ALTER TABLE B ADD PRIMARY KEY (ID, SubName); HTH! Aleem -Original Message- Sent: Monday, September 02, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Unique value sultan