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

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

How to load mysql (and other) extensions into PHP
How to load mysql (and other) extensions into PHP PHP Development forum discussing coding practices,

ASP.NET Validation Event Cycle
Hi,
I have asp button as follow:

help with calculations on a flat text file
hello,
I have this code below that is attached to a flat file like this:
Email:LastName:FirstN

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

Trigger tag in aspx is not coming
hi all ,iam new to ajax, iam using file upload inside the update pannel but right now i want to use

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