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

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

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

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther

Variable passed to each() is not an array or object
Hi,

This is a email a friend type of form, and it isn't working anymore.

<?

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

PHP, jAVASCRIPT setting input values, why isn't it working?
Hi:

I am calling this javascript:
<script language="javascript">

Need a Timecode Class...
Not a Time Stamp, Time Code. Format is a bit different. HH:MM:SS:FF where FF is Frames. I dont re

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

DateObject and Nulls
Hi all,

I have an array mapped to a value object. One of the items in the array is a PHP Date

pull content
I have an existing page, domain/adverts.php which has a good PR. I've just rebuilt my site and the n