Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 Wed Jun 23 1999 - 22:37:24 CDT