audsid = SYS_CONTEXT('USERENV', 'SESSIONID')
You could have guessed it :-).
>----- Original Message -----
>From: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Tue, 05 Nov 2002 00:23:28
>
>Hello
>
>A user log is maintained for a table.I want to log
>all updations made to
>this table.
>I have written a database trigger (After Update) to
>log the changes to
>another table.My requirement is to find the
>machine name from which the
>updation has occurred and log the machine name also
>.
>How to get the currently working session ID so that
>machine name can be
>retrieved fromV$session view or any other method to
>retrive the machine
>name uniquely.
>
>Is it that one Oracle user can have multiple active
>sessions on different
>machines? Eg.
>User Name Status Module Session
>Machine
>XX ACTIVE SQL*Plus 10 AA
>XX ACTIVE SQL*Plus 19 BB
>
>Regards,
>Deepa
>
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>--
>Author:
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and
>web hosting services
>To REMOVE yourself from this mailing list, send an
>E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of
>'ListGuru') and in
>the message BODY, include a line containing: UNSUB
>ORACLE-L
>(or the name of mailing list you want to be removed
>from). You may
>also send the HELP command for other information
>(like subscribing).
>---------------------------------------------------
>------------------
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroul
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
