Select name from v$database;
Chris.
-----Original Message-----
From: Suresh Kanubaddi [mailto:oracledba-ezmlmshield-x62313271.[Email address protected]
Sent: Friday, September 29, 2006 12: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
Oracle LazyDBA home page