Re: columns of a unique index

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Wed, 14 May 2008 16:03:26 -0400
Message-ID: <74f79c6b0805141303o60f06cese9190210e17f6ba9@mail.gmail.com>

It is allowed to have nullable columns in a unique index. However, in a Primary Key constraint all the columns has to be NOT NULL.

A unique key could more accurately be referred to as an Alternate Key.

Finn

On 5/14/08, Oxnard Montalvo <oxnard_at_carolina.rr.com> wrote:
> Think it is ok to have them nullable? why or why not. Seem like in general they act as another PK on a table.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 14 2008 - 15:03:26 CDT

This message: [ Message body ]
Next message: TESTAJ3_at_nationwide.com: "Re: how to check "license high water mark" without shutdown database?"
Previous message: Finn Jorgensen: "Re: filesystemio_options setting"
In reply to: Oxnard Montalvo: "columns of a unique index"
Next in thread: Powell, Mark D: "RE: columns of a unique index"
Reply: Powell, Mark D: "RE: columns of a unique index"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message