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

Insert numbers from Barcode scanner into online php page
I have a real big problem, Here is what I'm trying to do. I have a Intermec CN3 handheld computer th

Connecion issue
Hi,

For some reason, I keep getting this error when trying to connect:

Warning: mysql_

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem: I have below button declaration in markup of the aspx page:

How to form a xml form table with a single sql statement..?
Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't

Content-Disposition: attachment; filename=... not working as i thought it should
taken the following code from the php.net site the script is not working.

what is not happeni

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

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