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: J Alex <jalexanderssd_at_yahoo.com>
Date: Wed, 24 Apr 2002 10:17:04 GMT
Message-ID: <ACvx8.69579$nc.10000619@typhoon.tampabay.rr.com>


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?
>
> Regards,
>
> Knut
>
>
>
>
Received on Wed Apr 24 2002 - 05:17:04 CDT

Original text of this message

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