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

Get dump of MySQL DB from Live Site
I'm after an easy, but secure way of generating and importing a MySQL dump from a remote server.

modifying a property of an object from a different class
I have 2 classes:
- Math
- Distance

in my math class, I have this line:
$distance =

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em

session checking in page load
hai all I have a web site is www.Mryas.com in this my login page is Page1.aspx its co

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

IP Based Cron Jobs
I run cronjobs on my website. After one of my visitors got curious and tinkered around he realized h

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