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

Please help understand this code
I noticed the index page on my site was modified this morning and found this code inserted at the bo

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

Word filter problem
Hello,

im trying to make a filter for words inputted in to my website but i want to store the

newbie question about multiple queries
hi everyone,
I'm sorry to ask such a basic question, but I'm young and trying to learn php on my

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

Storing/displaying image urls in a database?
Hi
Basically I have the following scenario:
User chooses picture from list. Picture info is ad

MySQL Does not UPDATE- SQLString Problem
vb Syntax (Toggle Plain Text) 1. SQL = "UPDATE sampletable SET column1 = 'C1sample1'"

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

Generate PDF
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t