col
parameter format a40
col value format a20
SELECT * FROM gv$option;
col comp_name format a30
SELECT comp_name, version, status FROM dba_registry;
set linesize 131
col property_name format a28
col property_value format a28
col description format a70
SELECT *FROM database_properties ORDER BY 1;
or
set pagesize 0
set linesize 121
col value$ format a40
col comment$ format a36
SELECT *FROM sys.props$
col value format a20
SELECT * FROM gv$option;
col comp_name format a30
SELECT comp_name, version, status FROM dba_registry;
set linesize 131
col property_name format a28
col property_value format a28
col description format a70
SELECT *FROM database_properties ORDER BY 1;
or
set pagesize 0
set linesize 121
col value$ format a40
col comment$ format a36
SELECT *FROM sys.props$