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

Storing Values taken from a DB...
Using this code it will generate a short list from my database

<?php
mysql_connect

fire away
i launched about 4 months ago as a lagit co. i have 2 paying clients, 1probono, 1 side progect, and

How to create a static html menu from a database
Hi,

I have built a small cms which allows me to create simple html pages and then upload them

Merger of 6 sister companies under one flagship company after go live
Dear Experts,
I need one help regarding Merger of sister companies of same group. currently we

Array becomes unset by itself?
Hi,

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

Menu restriction
How can I restrict the individual menu that would appear when a user logs in so that all users are c

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Help me with some material on Open Text Overview.
Hi Experts,
Please help me out with some material on Open Text. I have been supporting AP Workf

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha