constraint problem in oracle
From: Sunny <sunnyb_at_vendtek.bc.ca>
Date: 2000/07/03
Message-ID: <8jr421$t45$1_at_newsfeed.smartt.com>#1/1
Date: 2000/07/03
Message-ID: <8jr421$t45$1_at_newsfeed.smartt.com>#1/1
Hi everyone
[Quoted] How can you create One-to-many (optional relationship) in Oracle, like i mean how can you specify your constraint on an optional relationship. I tried to put the primary from one table to another table but didnt specify that it references to another table, that works but I was wondering if there is any other way in Oracle i can do it. so it will be one to many relationship but optional what do i have to set in the contraints tab.
[Quoted] One more question, when you set a foreign key in a table can it be null or not.
thanks a lot
Sunny Bagri
Oracle Developer
Received on Mon Jul 03 2000 - 00:00:00 CEST