Find current logon time

Posted on 16th Feb 2014 07:03 pm by admin

Hi,
in my sql script i want to query and find out the logon time of the current session.

If i connect to the gv$session table, i have to pass other variables like current SID, INST_ID, ... to identify the record of the current session
and then fetch the logon time value

Instead, i am looking for much simpler function like SYS_CONTEXT

Thanks

Your Answer:

Login to answer

Other forums

issues verifying if user is logged in
I am having issues when a user logs in via asp Login control, the IsAuthenticated still seems to com

Login Functionality Working Different on IE
This is an odd one, I have a site which has an admin section. The admin pages unsurprisingly require

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

difference between datetimes
($row['totime']-$row['fromtime'])/60

this is giving me 0

example of totime and fromtim

Creating a db with a query
Hello everyone.
I'm having troubles creating a db with a query.
I'm reading a book called PHP

passthru() help
Hi everyone,
I'm new to the forum and to PHP. I have some pretty good experience writing shell sc

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

HELP with mysql_real_escape_string
I'm looking to remove apostrophes completely when someone enters lyrics but don't have a clue how to