Oracle Database 19c -- Unpivoting Data Template

Problem

You want to have a sample template how to unpivot single line data

Solution

select 'INFO' type , t.* from (
select 
    name DB_NAME , 
    database_role DB_ROLE,
    db_unique_name DB_UNQNAME
from v$database 
) unpivot (value for name in (
    DB_NAME     as 'DB_NAME', 
    DB_ROLE     as 'DB_ROLE',
    DB_UNQNAME  as 'DB_UNQNAME'
) ) t