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

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

problem in pagination when processing with selectbox form
Hi,

I have a search form, with select boxes, if am selecting the value from the form, it work

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($