Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Heading display in SQL
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