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

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

Error in query: Resource id #4??
hey guys, having a minor (i think) problem here that i havent been able to figure out. long story sh

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they

Set Categories
I am creating a submission form for somebody to come in and submit products. These products are sep

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

ScriptResource.axd gives an error on fresh install of ASP.NET Ajax 1.0
Hello,I have a fresh install of Microsoft ASP.NET Ajax 1.0. When I create an Ajax enabled website in

strptime() equivalent for php4 ?!
Greetings!

this is my first post, thank you in advance for your replies.

Well, the ti