New answers tagged oracle-10g
When you leave it on database to decide, it will try to convert char to number, because it can compare numbers more fast.
I'm not sure if I understood the problem correctly, but maybe you're looking for something like this? Select to_char(add_months(last_day(TO_DATE(&DTE,'YYYYMMDD')),-1), 'MM') ||'-'|| to_char(add_months(last_day(TO_DATE(&DTE,'YYYYMMDD')),-1), 'YYYY') AS Month, sum(case when (AP.ASSET_TYPE like 'CFTD%') then ABS(AP.Eval_Market_Value) else 0 end) as ...
Top 50 recent answers are included