Re: format of the output

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:vdWdnboPlaA9I6bdRVn-gw_at_comcast.com...
>
> "Vu Pham" <vu_at_sivell.com> wrote in message
> news:c1ge5r$1id6bc$1_at_ID-219297.news.uni-berlin.de...
> | Two of the fields in my table are NAME CHAR(30) and SECTION CHAR(1)
> |
> | The following SQL produces the corresponding result;
> | -----------------------------------------------
> | SQL> select name, section from tablea;
> |
> | NAME S
> | ------------------------------ -
> | User 0 S
> | User 1 E
> | User 2 M
> | ------------------------------------------------
> |
> | Is there anyway to control the field width of the output, something that
> can
> | give me a result like ?
> | NAME SECTION
> | -------------- -----------
> | User 0 S
> | User 1 E
> | User 2 M
> |
> |
> | Thanks,
> |
> | Vu
> |
> |
>
>
> you need the SQL*Plus COLUMN command, ie
>
> column name format a14
> column section format a7
>
> note that these commands are in affect for the duration of the SQL*Plus
> session (until you exit the tool) or until they are reset -- they are not
> tied to a specific SQL statement, so they will be applied to the results
of
> any column with the specified name
>
> check out the SQL*Plus guide for a lot more interesting settings
>

Thanks, Marc. Just downloaded the sqlplus pdf. Yes, it's interesting - and overloads me :-)

Vu Received on Tue Feb 24 2004 - 19:22:24 CST