Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Heading display in SQL

Re: Heading display in SQL

From: <Christopher.Jones_at_oracle.comX>
Date: 24 Jul 2002 18:17:13 +1000
Message-ID: <uu1mp35h2.fsf@oracle.comX>


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.
Received on Wed Jul 24 2002 - 03:17:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US