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
and then fetch the logon time value

Instead, i am looking for much simpler function like SYS_CONTEXT

Thanks

Your Answer:

Login to answer

Other forums

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma

Php Mysql Page Loading Notice
Hi all,

I was wondering if there is a way (Sure there is) of showing a message or an image wh

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

SCRIPT ERROR
Here is the CONTACT FORM I made for our website:

<form id="form1" name="

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext

php/mysql auto logout after 2 hour and reset password
Hi all,

This I hope will make sense. I've the following code which when a user logins in, cr

onclick problem
I have <input type="text" name="message">
<a href=page2.