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

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But

PHP hyperlinks generator
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i

PHP5/Zend 2.0 - Resources
PHP5 Snapshots
http://snaps.php.net/

ZEND 2.0 Feature Overview and Design (PDF File

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes