C # access oracle database returns an empty set, can query to the data in PLSQL, Unicode=True; Direc-CodePudding

Select 'mining' kqtype2,
To_char (sum (e. "" producing oil (ten thousand tons)," "), '99999999999.9999') yearYou,
To_char (sum (e. "" producing gas (ten thousand)," "), '99999999999.9999') yearQi,
To_char (sum (e. "" tired oil (ten thousand tons)," "), '99999999999.9999') leiYou,
To_char (sum (e. "" tired gas (one hundred million)," "), '99999999999.9999') leiQi,
To_char (sum (e. "" tired to produce condensate (ten thousand tons)," "), '99999999999.9999') leiNi,
The sum (e. (ten thousand) "" "" LeiFang air) leiAir
The FROM MR_OG_min_ITEM a
The join SI_OG_min_WELL b
On Anderson D_LICENCEID=b.I D_LICENCEID
And a.Y EAR=b.Y EAR
The join BASE_WELL c
On b.w ellid=c.w ell_id
The join MV_A2_PRO_MON e
On e.A ID=2 Wells c.a. 2 _id
During the where a.Y EAR=@
And e. monthly='@ yearmonth'

CodePudding user response:

Troublesome everybody Daniel look