Home » SQL & PL/SQL » SQL & PL/SQL » how to find session information by trigger
how to find session information by trigger [message #38376] Tue, 16 April 2002 01:06 Go to next message
Simon
Messages: 60
Registered: December 1998
Member
How to find session information by trigger

Report message to a moderator

Re: how to find session information by trigger [message #38551 is a reply to message #38376] Fri, 26 April 2002 04:39 Go to previous message
Saga
Messages: 51
Registered: April 2002
Member
Use the following select statement to retrieve the user session information
SELECT USERENV('sessionid')
INTO nsessionid
FROM DUAL;
Hope it will help.

Report message to a moderator

Previous Topic: Converting table into control file
Next Topic: CLOB problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 16:02:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.