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

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

setcookie and isset($_COOKIE(name)) seem very finnicky.
I'm currently playing around with a user system with login and registration. I'm trying to use cooki

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place. I have a main window with a ajax grid

retrieving more than one max key from an array?
so i have an array of 20 numerical values (0-100) that i need to order from highest to lowest and th

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

BackButton Behaviour in AJAX
I have an ASPX Page AJAX Enabled!The page has a gridView and a DDL for filtering on it. The Gridview

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have