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

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Multiple PHP errors when clicking a link..and..removing a ghost..
Hi - I have 2 problems with a new website - homeswapvacations.com, which I need help solving.

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

IF Statement & Two Tables With Different Echoes
I'm retrieving two tables in a single query using UNION ALL, like so:

Code: $query = "SE

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Mail Form receiving emails with no content
Hi, I hope someone here can help me.
I have a simple form in my website, it was working OK, after

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

for loop without same $i digits?
Hi,

Can some guru please advise how can I accomplish this with a simple for loop ?

I