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

what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

Syntax Help
Code:


im having trouble with that code snipped
Parse error: syntax error, unexpec

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

Simultaneous select/update/insert
Hi

How would I need to go about when 2 users update a single row simultaneous? And how would

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

Parse String
I need to parse the string below into three variables. How would I do that?

john + 10/20/2008

Probably a simple error...
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen24