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

help countdown timers
hello every one,

I'd like to know how to insert many countdowns in the same page.
The dura

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Variable Clash
In the past I've had variables clash. For example:

Code: <?php
$c = 5;
$ca

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

RFQ Configuration - can you make PLANT field an optional field in ME42
Is there a way to make the plant field on an RFQ optional in change mode (ME42)?

form class help (oop php5)
Hidy Ho Neighbors,

I'm forcing myself to learn oop/classes for php5. It seems like a good id

mail() problem
Hi Guys,

I've set up a contact email form. It sends the information fine, but it sends it to

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Extract specific information from a PHP Multidimensional Array
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear

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