Dummy Column in Oracle

Sometimes it becomes necessary to add a dummy value next to a dummy column in a report. It can be done easily using the below command :

select sum(amount_auth/100) as “Total”, ‘Months’ as dummycol from log_record where void_code=’0′ and bin in (‘4119813′,’4119814′,’4119815’)
and sec_tran_code = ‘PURH’;

OUTPUT

Total                                                  DUMMYCOL
——————–                           ——————————–
105145582                                      Months

1 row selected.

Leave a Reply