Home » SQL & PL/SQL » SQL & PL/SQL » foreign key defined on thre fields
foreign key defined on thre fields [message #1526] Thu, 09 May 2002 01:07 Go to next message
Pilar
Messages: 1
Registered: May 2002
Junior Member
Hi,

I have a FK defined on three fields, but i do not know how Oracle works with this kind of FK. The problem (perhaps it is not) is that when one of the fields of the FK is null in the child table, Oracle does not give me an error of invalid value and saves the record. Obviously if I enter a wrong value in some of the fields, Oracle tells me that there is a violation of FK. Is this behaviour correct?

Thanks, Pilar

Report message to a moderator

Re: foreign key defined on thre fields [message #1528 is a reply to message #1526] Thu, 09 May 2002 04:34 Go to previous message
Sowrirajan
Messages: 4
Registered: March 2002
Junior Member
Even if u have one FK ref. if u enter null in the child table it will not give any error.

Report message to a moderator

Previous Topic: Text_io problem
Next Topic: report conversion in excel
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 01:17:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.