SQL Script Database Info

Updated : 28-Mar-2002
Version : 2.0

Description

Basic Database details - useful to put in as part of a glogin.sql script if you have lots of database on one machine.

Parameters

None.

SQL Source

CLEAR
SET HEAD ON
SET VERIFY OFF
SET FEED OFF

alter session set nls_date_format='DD-MON-RR' ;

col instance_name form a8 Heading "Instance"
col name form a8 Heading "DB Name"
col host_name form a12 Heading "Hostname"

select dbid
	,name
	,instance_name
	,host_name
	,created
	,log_mode
	,open_mode 
from v$database, v$instance
/

set feed on

Previous Oracle Version Links

Database Info

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal