/* ************************************************ */
/*                                                  */
/* Script: Display database status as recorded      */
/*                                                  */
/* name:    @c:\oracle\sql\v$instac.sql             */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select * 
from v$instance;

/* convert the julian date to the standard date format */

select to_date(value, 'J') "START-UP"
from v$instance
where key like '%JUL%';

commit;

