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

a very simple php header question (sorry!)
Firstly...I do apologise if this annoys anyone....a header error

I'm do not know php &

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen

Combining refCursors and Summing
Given the following DDL:

CREATE TABLE FOODSALESTEST ("WEEKNBR" NUMBER, "ST

Sort a two dimensional array.
Hi. I've set up a two dimensional array that reads as follows:

Code: $modifiedData = array(

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Last Weeks sDate and eDate.
sDate - Start Date
eDate - End Date

I need to pull two dates for "Last Week" whi

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items