Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

adding a dummy field to an oracle sql query

729818May 24 2011 — edited May 24 2011
Hi, 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2011
Added on May 24 2011
2 comments
14,069 views