OraFAQ Forum: Server Administration » Unique constraint Problem

Home » RDBMS Server » Server Administration » Unique constraint Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unique constraint Problem [message #371909]

Tue, 19 December 2000 09:03

ramesh
Messages: 123
Registered: August 2000

Senior Member

I have a column in a table which is Nullable.
I want to use ALTER TABLE command to change this column to UNIQUE.
Is this possible?

Report message to a moderator

Re: Unique constraint Problem [message #371936 is a reply to message #371909]

Fri, 22 December 2000 12:11

Kathy
Messages: 10
Registered: October 2000

Junior Member

yes possible,provided there are no two values(except nulls.) are same in that field.
Refer oracle concepts manual.

Report message to a moderator

Re: Unique constraint Problem [message #371937 is a reply to message #371909]

Fri, 22 December 2000 22:58

ramesh
Messages: 123
Registered: August 2000

Senior Member

Thanks Kathy.
Can u do me a favor? I do not have access to a copy of the concepts manual.
Can u send me a code snippet??
It will be very useful.
Thanks.

Report message to a moderator

Re: Unique constraint Problem [message #371938 is a reply to message #371909]

Fri, 22 December 2000 22:59

ramesh
Messages: 123
Registered: August 2000

Senior Member

Thanks Kathy.
Can u do me a favor? I do not have access to a copy of the concepts manual.
Can u send me a code snippet??
It will be very useful.
Thanks.

Report message to a moderator

Re: Unique constraint Problem [message #371950 is a reply to message #371909]

Tue, 26 December 2000 15:34

Kathy
Messages: 10
Registered: October 2000

Junior Member

hope this will help you.

ALTER TABLE table_name
ADD CONSTRAINT constraint_name
UNIQUE(column_name)

Report message to a moderator

Previous Topic:	VIEWS and Stored Procedure
Next Topic:	Please help us ....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 11:35:53 CDT 2024