Re: constraint problem in oracle
From: Eric Givler <egivler_at_flash.net>
Date: 2000/07/05
Message-ID: <IRM85.5920$7%3.470074_at_news.flash.net>#1/1
Date: 2000/07/05
Message-ID: <IRM85.5920$7%3.470074_at_news.flash.net>#1/1
>How can you create One-to-many (optional relationship) in Oracle, like i
>mean how can you specify your constraint on an optional relationship.
alter table child_table add ( constraint fk_emp_Deptno (deptno) references dept );
>One more question, when you set a foreign key in a table can it be null or
>not.
yes. Received on Wed Jul 05 2000 - 00:00:00 CEST