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

include
Hi I have this way of licensing my PHP application, and I want to know if you guys can answer some q

Preventing blank or already entered values
Im trying to learn how to place a read file line by line and prevent duplicate entries and also BLAN

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

Problem with shopcart code
Hello, I am having a bit of trouble being able to add a product to my shopcart. My mysql database i

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a mes

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

foreach result into a single variable
Hi,

I have this code...

Code: [Select]foreach ($_POST['Interests'] as $interest =&