Re: Heading display in SQL

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 24 Jul 2002 00:52:30 -0700
Message-ID: <c42168e7.0207232352.91933a5@posting.google.com>

"Peter van Rijn" <p.vanrijn_at_rm-this.zhew.nl> wrote in message >
> one-
>
> select price1 || '|' || price2 || '|' || price3 "Comm.|Paid|Profit" from
> pricelist;
>

Thanks, this works fine but the below one

>
> two-
>
> column concatcol heading "Comm.|Paid|Profit"
>
> select price1 || '|' || price2 || '|' || price3 concatcol from pricelist;
>
> The latter method provides more flexibility.
>

The output is :

Price1
Price2
Price3

---

100|50000|500
100|25000|400
50|25000|100

for the first one requires much sga heap. Any suggestions for both.

Thanks very much Received on Wed Jul 24 2002 - 02:52:30 CDT