Hi Santa....you are back !! :))
I have copied the exact code from my machine but the only difference is that the machine names in the actual database are bigger (for example) : CDT\BNSEN9238743
I want to net send a message to logged on users:
select distinct 'net send ' || substr(machine,instr(machine,'\')+1) || ' This is a test' ,machine from v$session
where terminal is not null
If my machine name is "ABC\MEERA" I expect the outpout to be "net send MEERA This is a test"
but I am...
Mufasa...Good question...I am supporting a sunsetting application (ends mid 2007)and the company does not want to invest further...
Let me know if there is one in Oracle 8
Thanks for your help anyway !
Is it possible to determine the last login date and time by a user into an oracle instance.
I do not need any suggestion for future use but want to determine when a list of my existing users had last logged on into my oracle instance.
Urgent !
Is it possible to determine the last login date and time by a user into an oracle instance.
I do not need any suggestion for future use but want to determine when a list of my existing users had last logged on into my oracle instance.
Urgent !
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.