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

How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else

I can give them an F

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

Problem related to Creation of PDF File?
Hi All,
I am facing a problem related to creation pdf file. when I am creating a pdf file of do

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

login to other site by sending post variables
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [

Pass sql into pl/sql and create RMAN duplicate script.
Hi,

I'm new to pl/sql and I'm trying to write a script that will generate some RMAN comma

Accessing element of object array
Hello

My object looks like this:


Array ( [0] => User Object ( [id] =>