Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to identify in a single way the value of a session
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
![]() |
![]() |