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

PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em

How to disable direct access to a file
Suppose I've 2 Files. 1.php & 2.php

I don't want anybody to access 2.php directly fr

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

phph within href not showing php if change ? to &
Code: [Select]<a href="<?php echo $puser; ?>?m=<?php=(($m-1)&l

Warning: mysql_num_rows() expects parameter 1
When i add quote at the end of this link
example:http://localhost/articlemania/category.php?cid=3

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

How to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe