Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table payments (
  payment number
) ;
insert into payments( payment )
select 11 from dual union all
select 11.1 from dual union all
select 11.11 from dual ;
3 rows affected

select payment amount from payments 
union
select sum( payment ) from payments ;


AMOUNT


11

11.1

11.11

33.21


create or replace view payments_view ( position_, description, amount )
as
select 
  1 
, 'item'
, to_char( payment, '999,999.00' )
from payments
union
select 
  2
, 'total'
, to_char( sum( payment ), '999,999.00' ) 
from payments
;
select description, amount
from payments_view
order by position_
;


DESCRIPTION
AMOUNT


item
      11.00

item
      11.10

item
      11.11

total
      33.21