Re: Newbie SQL help needed - URGENT

pawanputrahanuman_at_yahoo.com said...
[snip]
> SUM(decode(upper(b.CATG),'OTH',b.PMT_AMT,null)) ||'|'||
> c.BRD_ALT_DS,
> c.EVENT_START_DT,
> c.PRICE_AMT

[snip]
>

sum(decode(upper(b.catg),'OTH',b.pmt_amt,null)) || '|' || c.brd_alt_ds || '|' ||
to_char(c.event_start_dt,'yyyy-mm-dd') || '|' || to_char(c.price_amt,'999.99')

-- 
/Karsten
DBA > retired > DBA