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

send() and recv() parameters confusion
On server Side:
int recv (Socket,Buffer, Length, Flags)
On Client Side:
int send (Soc

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

PHP Display Telephone Number On Referrer
I have used the php below to show a different telephone number in the header of the site depending u

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

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

Which par

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

Unidentified index error in a simple form
I have been trying to make an HTML form that is handled by a PHP script. So far my attempts to get i