SQL> col PARAMETER format a30
http://www.rocworks.at/wordpress/?p=430
SQL> col "SESSION" format a30
SQL> col DATABASE format a30
SQL> col INSTANCE format a30
SELECT * from
(SELECT 'SESSION' scope, nsp.* FROM nls_session_parameters nsp
union
SELECT 'DATABASE' scope, ndp.* FROM nls_database_parameters ndp
union
SELECT 'INSTANCE' scope, nip.* FROM nls_instance_parameters nip
) a
PIVOT (LISTAGG(VALUE) WITHIN GROUP (ORDER BY scope)
FOR scope
IN ('SESSION' as "SESSION",'INSTANCE' as INSTANCE,'DATABASE' as DATABASE))
/
Oracle Pivot Query (row to column)...
- Last update:
- 2014-05-23 11:04
- Author:
- Andreas Vogler
- Revision:
- 1.0
You can comment this FAQ