Re: Heading display in SQL

irfan_pk_at_hotmail.com (Md Irfan) writes:

> "Peter van Rijn" <p.vanrijn_at_rm-this.zhew.nl> wrote in message >
> 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

Use SET HEADSEP OFF to prevent the "|" being treated as a new-line meta character in the heading. See
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/ch13.htm#1012631

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.