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.

Category: DatabaseSQL

Tags:

Leave a Reply

Article by: Shadab Mohammad