In which case composite primary key allows NULL values in it
933937Jun 10 2012 — edited Jun 10 2012Hi to all
In what case composite primary key allows nulls in it.
Let us suppose, I created a composite primary key with 2 attributes.
CREATE TABLE sample
(
BNK_Id NUMBER(6),
BNK_Name VARCHAR2(20),
CONSTRAINT BNK_Id_Name_PK PRIMARY KEY(BNK_Id,BNK_Name)
);
When it allows null values in it.
thanks in advance