I believe you can also do it from
dbms_sessions package (dbms_session.unique_session_id)
Marc Billiet wrote:
>
> Try one of the following:
>
> select sid from sys.v$session where audsid = userenv('sessionid');
>
> or:
>
> select distinct sid from sys.v$mystat
>
> Marc
>
> Helmut Hahn wrote:
> >
> > Andreas Dunker wrote:
> >
> > > Hi *,
> > >
> > > how do I get the session id of the current connection;
> > > for example in sqlplus
> > >
> > > select something from someviewortable;
> > >
> > > Andreas
> > >
Received on Wed Oct 14 1998 - 14:52:11 CDT
