Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to identify in a single way the value of a session

Re: How to identify in a single way the value of a session

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Wed, 24 Apr 2002 10:55:55 +0200
Message-ID: <3CC6731B.6020209@mytoys.de>


Epicentre Team A ANNECY wrote:

> Do you think this that the column "VALUE" of v$mystat is ok for use it on a
> primary key ?
> Why not use "SADDR" of v$session ?

Of course it is NOT ok. Neither VALUE nor SADDR should be used. You want a _primary_ key, not just a key. Primary means also unique but the data you want to use is not unique when you insert more than one record per session. Why don't you use a sequence?

Regards,

Knut Received on Wed Apr 24 2002 - 03:55:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US