Re: Heading display in SQL

On 23 Jul 2002 03:39:01 -0700, irfan_pk_at_hotmail.com (Md Irfan) wrote:

>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.

The best solution is

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

set colsep |

 select price1, price2, | price3 from pricelist

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 23 2002 - 12:42:06 CDT