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

Download Image from URL and Upload it
Ok, I have been googling for the last 1/2 hour trying to figure this out, Most likely I'm just not s

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but i

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

Unable to retreve the values from Mysql Query
Hi,

Here is the php code that I have, Query is running properly in phpmyadmin and is resu

File upload issues
Hi Guys,

Can anyone see any issues with this code:
Code: [Select]$setImage= 'productimages

error with opendir
when i do this

if ($handle = opendir($dir)) {
while (false !== ($file = readdir($han