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
Did you know?Explore Trending and Topic pages for more stories like this.
and then fetch the logon time value

Instead, i am looking for much simpler function like SYS_CONTEXT

Thanks
No comments posted yet

Your Answer:

Login to answer
298 Like 24 Dislike
Previous forums Next forums
Other forums

Code clarification
Hi

In the following code what could be the "search_print()" and where it could be

registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

why is it over writing
Code: $filepaths[] = $_FILES['new_image'];
foreach ($filepaths as $filepath)
{
$imagename =

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Warehouse Management
Hi,

On our system, we have two storage locations ( A and B ) where A is the main factory

ok i need to join all this pages to make 1 neat code
i have 5 pages that make up my tv guide it works 100% but i want to make it 1 page if i can or 2, i

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash