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: Peter van Rijn <p.vanrijn_at_rm-this.zhew.nl>
Date: Wed, 24 Jul 2002 11:52:22 +0200
Message-ID: <ujsu2q9tgfml8d@corp.supernews.com>


Of course, I'm sorry, I was not in the opportunity to test it before submitting the the group.

Peter

<Christopher.Jones_at_oracle.comX> schreef in bericht news:uu1mp35h2.fsf_at_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 - 04:52:22 CDT

Original text of this message

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