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

Help on code output
My CODE:

Code: [Select] echo "<phone>".$line["phone"].&qu

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

Warning: Cannot modify header information - headers already sent by (output sta
Warning: Cannot modify header information - headers already sent by (output started at /home/praylif

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

confused between ' ' and " "
there is a php i set:
$begin_date_query = mysql_query( "SELECT SUBDATE(due_date, INTERVAL $d

How to add an image/C++ OpenGL?
Hi,

I have been trying to look online for this and, so far, I haven't found anything usef

Batch Session SM35 stuck in status 'in Background
Hi Experts,

I am facing a problem with Batch Input session SM35.

The batch se

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:

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

add to sql result
ok see rite now my sites hit counter is counted from the mysql visitor log i need to clear it aft