Not null in composite key?
443808Jul 13 2005 — edited Jul 19 2005I created one table as:
create table abc
(f_name varchar2(50),
m_name varchar2(50),
l_name varchar2(50),
CONSTRAINT UK_NAME UNIQUE (f_name,l_name,m_name)
)
Here I want to keep NOT NULL Constraint on the composite key. Something like
CONSTRAINT NOTNULL_NAME NOT NULL (f_name,l_name,m_name)
How to do this?
Regds,
Ashish