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

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell