Thanks Karsten. But it does not work.
Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<MPG.19368fe941161d5e98978d_at_news.la.sbcglobal.net>...
> 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')
Received on Fri May 23 2003 - 15:06:40 CDT
