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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s