Logo

SQL Script

Database Info

 Tested on Oracle 8.0 Tested on Oracle 7

Updated : 28-Feb-2001
Version : 1.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

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 - v8i only */
from v$database, v$instance
/

Return to Index of SQL Scripts

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

Logo