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

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

Request for tunning the below query
Hi,

Can any one help me on the below query while improving the performance,

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:

Code: [Select]$query

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

Simple program to copy files between two computers over the web
I use logmein free and often need to move files between my two computers. Generally, I move the file