Re: What is unique_id in Oracle and what's the use of it

On 30.01.2008 07:04, news.verizon.net wrote:
"newa" <DavidLLiu1@xxxxxxxxx> wrote in message news:3a4b8be1-1ce8-4402-9e94-1c295e22e871@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.

What does it sound like?

Homework question.

:-)

robert
.

Relevant Pages

  • Re: Functional Indexes?
    ... The fact that one of the row types has a different set ... the other row types the primary key is not unique is proof. ... record table with several different child tables one for each content ... The solution came from an Oracle DBA guru who's ...
    (comp.databases.informix)
  • Re: Primary Key and Indexes, are they necessary?
    ... The vendor responsed that the reasons they do not add the primary key ... Indexes do slow down data entry. ... Indexes should always be evaluated and have a reason for existing. ... In Oracle 10g, the Cost Based Optimizer has been improved to the point ...
    (comp.databases.oracle.misc)
  • Re: Primary Key and Indexes, are they necessary?
    ... The vendor responsed that the reasons they do not add the primary key ... Indexes do slow down data entry. ... Indexes should always be evaluated and have a reason for existing. ... In Oracle 10g, the Cost Based Optimizer has been improved to the point ...
    (comp.databases.oracle.misc)
  • Re: .net table adapter code behind missing UPDATE statement
    ... Check to make sure that the TABLE you are working with has a PRIMARY KEY ... Once you get beyond this you are going to like working with .NET and Oracle ... is sql server this option is enabled). ... but not the Update command (note if the source db is sql ...
    (microsoft.public.dotnet.general)
  • Re: QSM-00781 on DBMS_ADVISOR.TUNE_MVIEW
    ... MV's on DUAL are impossible, for DUAL has no primary key. ... Do you have the ADVISOR role? ... Copyright 1982, 2005, Oracle. ... It is generally a bad idea to name variables after reserved words. ...
    (comp.databases.oracle.server)