Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi How do i get the server name

Status
Not open for further replies.
cyno

cyno

Programmer
Oct 1, 2003
90
US
Hi

How do i get the server name in oracle.Iam new to oracle.
In MSSQL we get the server name as select @@servername.
 
Sort by date Sort by votes
Cyno,

select host_name from v$instance;

HOST_NAME
----------
foster

[santa]Mufasa
(aka Dave of Sandy, Utah, USA @ 00:18 (17Dec03) GMT, 17:18 (16Dec03) Mountain Time)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle Simphony - GetPrintedCheck
Replies
0
Views
160
japl93
J
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
2K
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
981
Andrzejek
Andrzejek
J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
160
jandresHDS
J

Part and Inventory Search

Sponsor

Back
Top