adding a dummy field to an oracle sql query
729818May 24 2011 — edited May 24 2011Hi, I'm trying to build a select statement that incorporates two dummy fields of text in the output so I can load this output to another system.
The first two fields of text I want to be the "dummy" text fields and each record should have "Budget, Final" as the first two fields of text for each row.
here's what I currently have and I'm having problems with:
select
'Budget' as "Scenario",'Final' as "Version",pa_id as "NewWells8",budget_status as "Wedge",year as "Year",month as "Months",ac_gross_gas_vol as "AC_Gross_Gas_Vol",ac_gross_oil_vol as "AC_Gross_Oil_Vol",ac_net_gas_vol as "AC_Net_Gas_Vol",ac_net_oil_vol as "AC_Net_Oil_Vol",ac_gross_condensate_vol,ac_net_condensate_vol,ac_total_capital_investment,nri_percent_oil,nri_percent_gas,gwi_percent,bpo_wi,bpo_nri,apo_wi,apo_nri
from
xxx_tablename;
this query sort of works but what I get is just a header row that says 'Scenarioo' and 'Final' but below that header row each of those two fields is blank. All other fields display data correctly.