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

Operating System
How in PHP or other language can I detect Operating system, ie Windows XP Home, Windows 7 Ultimate,

News script
Hi ...

I am not sure if this is the rite place to post this but if its not sorry

i am

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

getAlexaRank($url) function not working
I have made a function to get alexa rank
the site is here: http://mytestsite.rack111.com/1

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

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

Using unserialize()
Hi there.

I have some data in my database that is serialized.

e.g.

a:2:{i:0

form problem
Hi all, I think this is going to be easy to resolve but for I have been looking at it to long and I