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
Did you know?Explore Trending and Topic pages for more stories like this.
and then fetch the logon time value

Instead, i am looking for much simpler function like SYS_CONTEXT

Thanks
No comments posted yet

Your Answer:

Login to answer
298 Like 24 Dislike
Previous forums Next forums
Other forums

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

strptime() equivalent for php4 ?!
Greetings!

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

Well, the ti

Easy administration on MySQL databases
My website is database driven and I am very tired of manually making queries to my tables in order t

this code is strange !
Hi i got this code from the web.. It checks for live and dead socks
It is working perfectly on my

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix

Coding Critique
I was hoping someone could take a second and look down my code and see if they see any problems with

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash