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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please explain what this question or answer has to do with PL/SQL or Oracle???????????????????

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I bet you can't get my computer name.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 26766
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
All you can get with SQL is all clients connected to a database (as Ana showed it).

Regards
Michel

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 15 08:43:41 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.