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

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Change of partner analyse in sales orders
Hello,

I changed the partner analyse for sales orders and added a new mandatory partnerro

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer

that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.html

I don't think my c

Executing an exe
Hi. I have some bizarre problem with exec (other any other method) to launch exe's. I am making a ga

how to use two buttons with php
hi i have one form. there are three fields which are to be filled by the user. and then there are tw