Thanks Guys!!!
-----Original Message-----
From: Chris Du Plessis (CC)
[mailto:oracledba-ezmlmshield-x78791952.[Email address protected]
Sent: Friday, 29 September 2006 4:01 PM
To: LazyDBA Discussion
Subject: RE: Database name
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
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 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
________________________________________________________________________
--------------------------------------------------------
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
________________________________________________________________________
Oracle LazyDBA home page