Tag Info

New answers tagged


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