Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Not null in composite key?

443808Jul 13 2005 — edited Jul 19 2005
I 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

Comments

Hans Forbrich
You may want to start by reviewing http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref483

Host is the physical computer, machine, operating system ... but not the database.

So in general, 'Host Login Credentials' means 'what is the computer username and password (not database user/pwd) of the user who is to login on the host (machine) in order to do the work?'

In this case, it's probably the userid that owns Oracle .... surely you did not install the database as 'Administrator'.
damorgan
There is a demo here:
http://www.morganslibrary.org/reference/wallet.html
that shows all of the moving pieces.

The page is part of the library located at:
http://www.morganslibrary.org/library.html
699363
Actually, this post provided the solution to my problem: 3755696

Thanks for the replies to my original post.
Hans Forbrich
Excellent. And thanks for posting the pointer to solution.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 16 2005
Added on Jul 13 2005
#general-database-discussions
10 comments
397 views