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 17:05:45 +0200
Message-ID: <3CC6C9C9.4060307@mytoys.de>


J Alex wrote:

> You can have two columns comprise a PK. But from what the request was
> (identifying rows that were inserted by someone whose session has since been
> terminated), it doesn't sound like making them a PK is necessary.
>
> "Knut Talman" <knut.talman_at_mytoys.de> wrote in message
> news:3CC67EEA.40007_at_mytoys.de...
>

>>J Alex wrote:
>>
>>
>>>Using both SID and Serial # from v$session worked for me when doing the
>>>exact same thing you're saying.
>>>
>>
>>How can you use it as a primary key?


What my question meant was: How can you use two values (which does not change) as a primary key (which has to be unique)?

Regards,

Knut Received on Wed Apr 24 2002 - 10:05:45 CDT

Original text of this message

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