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

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When

Required to login help
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been

Does design fit in FPGA ?
Hi all,

I've made a large HCC-Design. Because of the program-size the compile process with th

PHP - MySQL Fail
My PHP code will only execute the first part of my code...

Code: <?php

sessio

Dump with added_funcion cl_salv_table
Hi there, I'm having some troubles adding a self defined function to an ALV in fullscreen. The thing

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon