Re: What is unique_id in Oracle and what's the use of it
From: venki <venkat.hb_at_gmail.com>
Date: Wed, 30 Jan 2008 03:01:04 -0800 (PST)
Message-ID: <625f5298-e511-4888-97e9-c8c868abf594@q39g2000hsf.googlegroups.com>
Date: Wed, 30 Jan 2008 03:01:04 -0800 (PST)
Message-ID: <625f5298-e511-4888-97e9-c8c868abf594@q39g2000hsf.googlegroups.com>
On Jan 30, 8:47 am, newa <DavidLL..._at_gmail.com> wrote:
> Hi,
>
> I am new to Oracle and today someone asked me about the "fference
> between unique_id and primary key. Which to use and why?" I know about
> the primary key but not unique_id. Can someone kindly give me an
> overview of it?
>
> Thanks in advance.
Primary key is the combination of NOTNULL constraint and unique key
constraint.
so it ll never allow duplicate and null value.But unique key allows
number of null value but it never allow duplicate value.
Do not compare this to MS sqlserver, bcoz it some what different from
oracle to sql. Bcoz unique key will alow only one null value.
venki Received on Wed Jan 30 2008 - 05:01:04 CST