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
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