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

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Variable Clash
In the past I've had variables clash. For example:

Code: <?php
$c = 5;
$ca

Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.

I have maxminds geoip lite installed and i

Loosing changed contents when used FM REUSE_ALV_GRID_DISPLAY
Hi,

I have used FM REUSE_ALV_GRID_DISPLAY in my program as below.

CALL FUNCT

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w