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

Contents of variable not echoing
Hey guys, hopefully this is an easy one...

In this line, the variables are not echoing out. T

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

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Wierd if else problem
Hi guys,

this probably aint wierd for you, but it seems like php is playin up to me. may b i

I got my hosting suspended XD
So I saw this challenge a day or so ago

http://www.programming-challenges.com/pg.php?page=dow

Why use interfaces in PHP (OOP)
I am learning OOP in PHP and its been a pretty good learning experience so far. What I didn't unders

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing