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

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext

Undefined variable when using $_SERVER['PHP_SELF']
Hi guyz, please suggest me something...
On first.php I have one input field NAME, and on posting

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Open browser page depending on XML results
Hello,

I have some PHP code that sends webbased from data to an external url ( in the form of

Strip Slashes Help
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and