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

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

Troubles with a spider class
I am building a spider that will crawl through random whitepages (eg. anywho.com, switchboard.com, w

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

How can I uploading Transactional Data from Legacy to New SAP system
Hell Gurus,

I am overwhelmed with questions on how to migrate huge volume of Sales Orders

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l

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