Re: Oracle SQL*PLUs-Report format question

By default, the heading separation character is a vertical bar '|'. So by preceding your SQL statement with the SQL*Plus command: COLUMN fld1 HEADING 'alias|name', you should get what you want. If you don't want to use the vertical bar, you can change it to some other character (maybe ^) with: SET HEADSEP '^' Bhavesh Gosar wrote in message <7krtnb$lr7$1_at_ebaynews1.EBay.Sun.COM>...
>Hi,
>
>I have the foll....
>
>Select a.fld1 "alias name" from tab1
>
>This will give me
>
>alias name
>==========
>fld1...
>....
>
>How do I get the "alias name" title on 2 lines instead of 1
>line...I think you cannot use "column" statement..
>
>Any Ideas...workarounds...
>
>Please reply to me directly...
>
>Bg
>
Received on Thu Jun 24 1999 - 05:37:24 CEST