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

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

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

Trouble verifying database password
Thankyou to everyone who responded to my last post (I can't find the posting, it has been buried). <

Reg Ex
Im trying to search for the string: srv_9 (Dead ???)

I thought to use preg_match, however I d

same querie, or a new one??
Hi guys,

I'm still working on this drop down list. I've got the actual drop down list to wor

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Facebook status update API
Hello,

So, I'm trying to create my first Facebook application with PHP.

Basic ideas fo

Confused with Loop
guys, i got confused with Looping...this is the case

I have 3 stocks, let say "Stock A&q

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne