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 -> Heading display in SQL

Heading display in SQL

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 23 Jul 2002 03:39:01 -0700
Message-ID: <c42168e7.0207230239.6428bed8@posting.google.com>


Hi,

SQL> column price1 heading "Commission"
SQL> column price2 heading "Paid"
SQL> column price3 heading "Profit"

SQL> select price1 || '|' || price2 || '|' || price3 from pricelist

PRICE1||'|'||PRICE2||'|'||PRICE3



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

Hence after setting the heading values, I would like to get Price1 as Commission, Price2 as Paid, Price3 as Profit, but I get the display only as Price1,Price2,Price3.
Any suggestions and Idea Please.

Thanks. Received on Tue Jul 23 2002 - 05:39:01 CDT

Original text of this message

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