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

mysql_affected_rows() usage
Possibly a MySQL issue, but the function that is not behaving in the anticipated way is a PHP functi

Where do I put CRON code
So I've figured out alot about how to automatically run a php function. I can't figure out where to

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&typ

Renaming array keys
The issue: renaming array keys inside a foreach loop.

I'm trying to build a pie chart image w

timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)
in my mysql db u

ok i need to join all this pages to make 1 neat code
i have 5 pages that make up my tv guide it works 100% but i want to make it 1 page if i can or 2, i

Help with captcha script needed
Hello,

I am working on a script where reCAPTCHA or a similar form of CAPTCHA will be used, f

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav