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

Data Function is Its Not working IN IE8
This is my first time to use formums. I hope i can get solution for this problem. view plaincopy to

Serial number of exernal hard disk/Thumbdrive
Hi guys, I am new tio java networking concepts.Please tel me how to get Serial number of exernal

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

sendmail code suddenly not working
Hi Guys, I maintain 3 sites (including my own) I use the following code from a french webmaster that

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

cyrillic string conversion question
Hello,

First time here...

I would like to know if there is a way to convert a

Limiting checkboxes?
Hi guys,

I have this code: Code: if(isset($_POST['selected'])) {
foreach($_POST['selec

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor