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

Text file to .Dat file Conversion in PHP
Hi All,
Could anybody provide code for Text file to .Dat file Conversion in PHP.

Tha

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s

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

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

JQuery, Masterpage, and Control issue
Hey everyone, I am using JQuery in several sites so I thought it would be best to place the library

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?

here is my code

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor