This is probably a very elementary question. I would like to have an sql
which returns the name of the Oracle server and the current database. Could
anybody help me out?
Regards,
Richard 4 87031
Thanks, Soeren. I found the last link helpful, but I don't see that the
first one really tells you how to obtain the name of the server?
"Soeren Degn Jahns" <no****@nospam. dk> wrote in message
news:A5******** ************@ne ws000.worldonli ne.dk... This is probably a very elementary question. I would like to have an sql which returns the name of the Oracle server and the current database. Could anybody help me out?
Server name etc.: http://www.orafaq.com/scripts/sql/ver.txt
Current database.: http://www.orafaq.com/scripts/sql/whoami.txt
// Soeren
> Thanks, Soeren. I found the last link helpful, but I don't see that the first one really tells you how to obtain the name of the server?
Hi Richard. Yeah, you're right. I was a bit too fast there, sorry. Would,
what you are looking for, be the global_name then:
SELECT global_name FROM global_name ;
This would be equivialent to:
SELECT ora_database_na me FROM dual;
Hope this helps?
// Soeren
"Soeren Degn Jahns" <no****@nospam. dk> wrote in message news:<A5******* *************@n ews000.worldonl ine.dk>... This is probably a very elementary question. I would like to have an sql which returns the name of the Oracle server and the current database. Could anybody help me out?
Server name etc.: http://www.orafaq.com/scripts/sql/ver.txt
Current database.: http://www.orafaq.com/scripts/sql/whoami.txt
// Soeren
Richard, you can find the database name in v$database while the
machine name for both the front-end and Oracle session background
processes can be found in v$session. The dynamic performance views,
v$..., are documented in the Oracle version# Reference Manual.
The sys_context function is a handy source of information about the
current session including Oracle username, Os user, Proxy user, IP
address, .... See the SQL Manual.
HTH -- Mark D Powell -- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Gmanuel |
last post by:
I want from VBA, be able to read what the host name of a text file is.
For example, if the file passed to the function is on a particular
server, I want to retrieve the name of the server it resides on. Does
anyone know how I can do this?
TIA,
Gary
|
by: David Bear |
last post by:
Let's say I have a list called, alist. If I pass alist to a function,
how can I get the name of it?
alist = range(10)
def afunction(list):
listName = list.__name__ (fails for a list object)
|
by: middletree |
last post by:
How do I request the actual page name that I'm on? This is going to go into
an include file, and depending on which page I'm on, I'd like to do
different things. I'm looking for "pagename.asp"
|
by: Jack-2 |
last post by:
Hi!
Three days ago I wrote in this group for ask help in the use of
"GetDetailsOf".
I want show the name of a file without the extension, and for this, a member
of this group suggestion me that
I will use this code:
name = fldr.GetDetailsOf(items, 0);
name = name.substring(0, name.lastIndexOf('.'));
|
by: asad |
last post by:
Hello friends, i need some help in getting uploaded file name, i am uploading
2 files and i want to get only the filename of these 2 file not a full path
so pls tell me which function or technique i use for getting this. I am using
ASP.NET built-in uploading.
Thanks.
| |
by: Ron L |
last post by:
I have an application I am developing which is using remoting to have a
smart client connect to a remote database via IIS. There are certain
functions that we only want the user to be able to access if they are
members of a certain group on the server. When the application is deployed,
the group will be a domain group, but for our developers the group is a
local group on the development machines. To check the group membership, I
am...
|
by: Jacand4321 |
last post by:
I'm trying to audit all the database activities using Server-side trace
in SQL Server 2000.
Basically I need to get the login information (login Id, Login time
etc) along with the name of the database.Can some one suggest a way to
do that?
Thanks in advance.
J
|
by: Adam Tibi |
last post by:
Hi,
Is there a way of getting the domain name of tghe currently executing site,
I tried using this silly code:
public static string GetDomainName() {
string serverName =
System.Web.HttpContext.Current.Request.ServerVariables.ToLower();
|
by: Richard Gjerde |
last post by:
This is probably a very elementary question. I would like to have an sql
which returns the name of the Oracle server and the current database. Could
anybody help me out?
Regards,
Richard
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |