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

Function
How can I make this function that once you click the link in the code it takes you to a new page wit

Problem writing URL into database
How would I write this into the database?

<?php echo "http://".$_SERVER['SER

Amend code to allow multiple attachments
Hi

I have a php page that allows the user to browse to a file (image) then sumbit, the confi

my two tables
table1 : col1 = topicid , col2 = topic

table2 : col1 = sentid, col2 = sentence

Cod

phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

grouping within a foreach?
hello all,

I currently have a list of products spit out from my db via a foreach loop. Right

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

C - Reading a file into a byte array
Hi,

I'm trying to read a file into a byte array in C. I have to use C as this is for a loadru