Try
Select * from global_name
Regards
Chris du Plessis
-----Original Message-----
From: Suresh Kanubaddi
[mailto:oracledba-ezmlmshield-x62313271.[Email address protected]
Sent: 29 September 2006 07:48 AM
To: LazyDBA Discussion
Subject: Database name
Hi,
As a normal user.. At the SQL promt how do I know which database I am
connected to ???
I can't remember this query which has only one field in it.
Regards,
Suresh.
--------------------------------------------------------
This email and associated attachments may contain confidential and
privileged CITEC information that is provided solely for the use of
the intended addressee. Views and opinions expressed in this email are
those of the individual sender and are not necessarily the views and
opinions of CITEC unless the sender expressly states that such views
and opinions are those of CITEC. The privilege and confidentiality
associated with this email and attachments will not be waived, lost or
rescinded by reason of mistaken delivery. Should you receive this
email by mistake, please notify the sender by return email then delete
the email from your computer system. You must not use, copy, modify,
print, or distribute the email or the information and attachments
contained within same to any third party. CITEC does not accept any
liability in respect of viruses or computer problems experienced by
the recipient through access gained to this email and its attachments.
--------------------------------------------------------
______________________________________________________________________
__
This email has been scanned for viruses by the CITEC Email Anti-Virus
service powered by MessageLabs. For more information on a proactive
email anti-virus service working around the clock, around the globe,
visit www.citec.com.au
______________________________________________________________________
__
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a dba job: http://jobs.lazydba.com To Subscribe :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oracle LazyDBA home page