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

No comments posted yet

Your Answer:

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

Effort Estimation Template for Steady State Support
Hi Everyone,

Is there any SAP provided template/format for system change and enhancements

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array

Help with file_get_html
The following code gives the expected results:

<html>
<head&g

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c

include problem
I have my root folder as:
Code: $root = $_SERVER["SITE_HTMLROOT"]; // the server root<

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri

Just cannot get 'area' to submit to db using same php code as already used
Basically all i have done is just modified some code and added an area section.
The form is allre

The repetition structure: the while statement not working
New programming student, have assignment as follows:
A restaurant has 4 lunch combos for custom

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

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