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

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Move array index to end
Hey guys,
Quick question:

I have an array that looks like this:
Code: [Select]$var =

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the

Using Microsoft Exchange Server with PHP
Hi,

I wanted to know if its possible to fetch email attachments from the exchange server usin

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

simplexml and xpath - Need some help
Hello,

I am trying to parse an xml which comes back from Amazon and I am trying to know how m

PHP Tab Control
Hi All,

I would like to have PHP tab control with/without Javascript.

But I want to r

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

retrieving policy name inside the function called by this particular policy
Hi there,

I've playing around with dbms_rls package, trying to set up some security repo