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

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

How To Make More Than One Redirection with PHP on the same page?
Hey im trying to do a direction page where it open differently link direction pages every time som

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

Big Problem!! Please help
Hi Guys,

Im making a website for a friend have encountered a really annoying problem. When ev

How to validate from 2 possible answers
Hi

I hope somebody can help me with what will probably be really simple, I'm pulling my hair

removing space from the end of a variable
i have a variable $image which contains the following url "http://tiles.xbox.com/tiles/oo/P5/0m

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p