Home » SQL & PL/SQL » SQL & PL/SQL » Question of foreign key
Question of foreign key [message #47] Tue, 08 January 2002 03:28 Go to next message
oranew
Messages: 6
Registered: January 2002
Junior Member
There are two demo tables in Oracle: EMP and DEPT in schema SCOTT. There is a foreign key DEPTNO in table EMP. I tried this SQL statement: 'insert into emp(empno) values(8888);' which is successful.
How can this row be inserted into EMP since the value in column DEPTNO is null? why this didn't voliate the foreign key constraint?

Report message to a moderator

Re: Question of foreign key [message #50 is a reply to message #47] Tue, 08 January 2002 04:16 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
null values allowed.. if you dont null values to be inserted specify not null on deptno in emp table.

Report message to a moderator

Previous Topic: foreign key and primary key
Next Topic: Question re Installation / Possible Conflicts
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 23 00:31:33 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.