Home » SQL & PL/SQL » SQL & PL/SQL » get name of all computer on network
get name of all computer on network [message #284881] Sun, 02 December 2007 07:09 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all
i want to get name of all machines connecte to network (ip of all computers on network).
thax
Rafeek
Re: get name of all computer on network [message #284885 is a reply to message #284881] Sun, 02 December 2007 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Please explain what this question or answer has to do with PL/SQL or Oracle???????????????????
Re: get name of all computer on network [message #284894 is a reply to message #284881] Sun, 02 December 2007 12:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet you can't get my computer name.

Regards
Michel
Re: get name of all computer on network [message #284906 is a reply to message #284894] Sun, 02 December 2007 17:05 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
i can get my computer name (client computer ) by
select USERENV('TERMINAL') from dual;

i want get all all client name on network;
thax
rafeek

Re: get name of all computer on network [message #284909 is a reply to message #284881] Sun, 02 December 2007 17:53 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
select machine from v$session

[Updated on: Sun, 02 December 2007 17:57] by Moderator

Report message to a moderator

Re: get all computer names on network [message #284960 is a reply to message #284881] Mon, 03 December 2007 00:26 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All you can get with SQL is all clients connected to a database (as Ana showed it).

Regards
Michel
Previous Topic: replacing/removing characters from strings (merged similar topics from same user)
Next Topic: Write the XML into CLOB using PL/SQL Procedure (merged 2 threads)
Goto Forum:
  


Current Time: Sat Dec 10 01:20:38 CST 2016

Total time taken to generate the page: 0.13073 seconds