Message-Id: <10697.123378@fatcity.com> From: "Nikunj Gupta" Date: Fri, 1 Dec 2000 00:50:04 -0800 Subject: Re: Primary keys vs. unique indexes This is a multi-part message in MIME format. ------=_NextPart_000_0086_01C05B30.A46AE2C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Primary keys vs. unique indexesHello Lisa, PRIMARY KEY means UNIQUE and NOT NULL... Hope that explains.. Nikunj ----- Original Message -----=20 From: Koivu, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, November 30, 2000 09:20 AM Subject: RE: Primary keys vs. unique indexes What? Yes you can. I have anyway.=20 Can you give me an example of when that would not work?=20 Lisa Rutland Koivu=20 Oracle Database Administrator=20 Qode.com=20 4850 North State Road 7=20 Suite G104=20 Fort Lauderdale, FL 33319=20 V: 954.484.3191, x174=20 F: 954.484.2933=20 C: 954.658.5849=20 http://www.qode.com=20 "The information contained herein does not express the opinion or = position of Qode.com and cannot be attributed to or made binding upon = Qode.com." -----Original Message-----=20 From: james ellis [mailto:jellis24_gso@yahoo.com]=20 Sent: Thursday, November 30, 2000 11:51 AM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Re: Primary keys vs. unique indexes=20 The main difference is you can not reference an unique=20 index with a foreign key.=20 --- cemail@sprintmail.com wrote:=20 >=20 > What is the difference between building a table and=20 > including=20 > the primary key versus building the table and then=20 > having creating=20 > a unique index on the same keys? When you create a=20 > table with=20 > a primary key, doesn't Oracle store it as an index=20 > anyway?=20 >=20 > -----=20 > Sent using MailStart.com (=20 > http://MailStart.Com/welcome.html )=20 > The FREE way to access your mailbox via any web=20 > browser, anywhere!=20 >=20 > --=20 > Please see the official ORACLE-L FAQ:=20 > http://www.orafaq.com=20 > --=20 > Author:=20 > INET: cemail@sprintmail.com=20 >=20 > Fat City Network Services -- (858) 538-5051 FAX:=20 > (858) 538-5051=20 > San Diego, California -- Public Internet=20 > access / Mailing Lists=20 >=20 --------------------------------------------------------------------=20 > To REMOVE yourself from this mailing list, send an=20 > E-Mail message=20 > to: ListGuru@fatcity.com (note EXACT spelling of=20 > 'ListGuru') and in=20 > the message BODY, include a line containing: UNSUB=20 > ORACLE-L=20 > (or the name of mailing list you want to be removed=20 > from). You may=20 > also send the HELP command for other information=20 > (like subscribing).=20 __________________________________________________=20 Do You Yahoo!?=20 Yahoo! Shopping - Thousands of Stores. Millions of Products.=20 http://shopping.yahoo.com/=20 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: james ellis=20 INET: jellis24_gso@yahoo.com=20 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing Lists = --------------------------------------------------------------------=20 To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20 ------=_NextPart_000_0086_01C05B30.A46AE2C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Primary keys vs. unique indexes
Hello Lisa,
 
PRIMARY KEY means UNIQUE and NOT=20 NULL...
 
Hope that explains..
 
Nikunj
 
----- Original Message -----
From:=20 Koivu, = Lisa
To: Multiple recipients of list = ORACLE-L=20
Sent: Thursday, November 30, = 2000 09:20=20 AM
Subject: RE: Primary keys vs. = unique=20 indexes

What?  Yes you can.  I have anyway. =

Can you give me an example of when that would not = work?=20

Lisa Rutland Koivu
Oracle = Database=20 Administrator
Qode.com
4850=20 North State Road 7
Suite G104 =
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: = 954.484.2933=20
C: 954.658.5849
http://www.qode.com

"The information contained herein does not express = the opinion=20 or position of Qode.com and cannot be attributed to or made binding = upon=20 Qode.com."


-----Original Message-----
From: james=20 ellis [mailto:jellis24_gso@yahoo.com]= =20
Sent: Thursday, November 30, 2000 11:51 AM =
To: Multiple recipients of list ORACLE-L
Subject: Re: Primary keys vs. unique indexes


The main difference is you can not reference an = unique=20
index with a foreign key.
---=20 cemail@sprintmail.com wrote:
> =
> What is the difference between building a table = and=20
> including
> the = primary key=20 versus building the table and then
> = having=20 creating
> a unique index on the same = keys? =20 When you create a
> table with =
> a primary key, doesn't Oracle store it as an = index=20
> anyway?
> =
> -----
> Sent using = MailStart.com=20 (
> http://MailStart.Com/welcome.h= tml=20 )
> The FREE way to access your mailbox = via any=20 web
> browser, anywhere!
>
> --
>=20 Please see the official ORACLE-L FAQ:
> = http://www.orafaq.com=20
> --
> Author: =
>   INET: cemail@sprintmail.com
>
> Fat City Network=20 Services    -- (858) 538-5051  FAX: =
> (858) 538-5051
> San Diego, = California        -- Public = Internet=20
> access / Mailing Lists
>
----------------------------------------------------------------= ----=20
> To REMOVE yourself from this mailing list, = send=20 an
> E-Mail message
>=20 to: ListGuru@fatcity.com (note EXACT spelling of
>=20 'ListGuru') and in
> the message BODY, = include a=20 line containing: UNSUB
> ORACLE-L =
> (or the name of mailing list you want to be = removed=20
> from).  You may
> also=20 send the HELP command for other information
> (like=20 subscribing).


__________________________________________________=20
Do You Yahoo!?
Yahoo! = Shopping -=20 Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/= =20
--
Please see the = official ORACLE-L=20 FAQ: http://www.orafaq.com =
--
Author: james ellis =
  INET: jellis24_gso@yahoo.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San = Diego,=20 California        -- Public = Internet access=20 / Mailing Lists
----------------------------------------------------------------= ----=20
To REMOVE yourself from this mailing list, send an = E-Mail=20 message
to: ListGuru@fatcity.com (note EXACT = spelling=20 of 'ListGuru') and in
the message BODY, = include a line=20 containing: UNSUB ORACLE-L
(or the name of =