OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » system name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

system name [message #244285]

Tue, 12 June 2007 04:37

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

how can i get current system name while runtime or with sql query.

Report message to a moderator

Re: system name [message #244287 is a reply to message #244285]

Tue, 12 June 2007 04:39

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What do you call the "system name"?

MHE

Report message to a moderator

Re: system name [message #244292 is a reply to message #244287]

Tue, 12 June 2007 04:52

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

thanks for replying

its pc's name from where i m login.
not server
but client pc's name i want
i want to track from which pc my software get logged in

Report message to a moderator

Re: system name [message #244294 is a reply to message #244292]

Tue, 12 June 2007 05:05

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

I think you can view it using

select distinct TERMINAL from v$session where MODULE= YOUR_SOFTWARE_NAME

But it shows all the terminals where your software is running.

Regards,
Sanka Cool

Report message to a moderator

Re: system name [message #244299 is a reply to message #244294]

Tue, 12 June 2007 05:16

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

thanks i want that

but i want one more thing i want can i find his ipaddress?

Report message to a moderator

Re: system name [message #244305 is a reply to message #244299]

Tue, 12 June 2007 05:21

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Do what I do: search the board Wink

.

MHE

Report message to a moderator

Re: system name [message #244306 is a reply to message #244299]

Tue, 12 June 2007 05:23

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select UTL_INADDR.GET_HOST_ADDRESS(terminal) from v$session
  2  where sid=(select sid from v$mystat where rownum=1)
  3  /
UTL_INADDR.GET_HOST_ADDRESS(TERMINAL)
----------------------------------------------------------------------
184.0.106.113

1 row selected.

Regards
Michel

Report message to a moderator

Previous Topic:	Why true argument is used in Raise_application_error?
Next Topic:	special character handling in translate query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 11:20:13 CST 2024