Re: SQL

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 20 Dec 2001 14:19:41 -0000
Message-ID: <3c21f386$0$227$ed9e5944@reading.news.pipex.net>

"Jan Burgers" <j.burgers_at_hccnet.nl> wrote in message news:9vsp5i$1cu$1_at_news.hccnet.nl...
> As a user of several different databases I'd like to know if there is way
> to make visible in my SQL screen to which database I am connected?

there is a topic about this (with a warning) at the cooperative FAQ at http://www.jlcomp.demon.co.uk/faq/sqlplus_prompt.html

alternatively you can issue the sql shown in the scripts at the sql prompt.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Thu Dec 20 2001 - 08:19:41 CST