Re: How to set col width in a query

Hi Jo,

in SQL*PLUS you cannot change the col during running a query, only before you
start the query you can format the output with col.

col columnname format a10 as example

RO

Joe Condle wrote:

> I know this is probably a newbie question. I have searched
> the documentation and can not find the answer. The question is
> how can I change the default column width in a query. The column
> widths in my database were made to large enough for the biggest
> piece of data. Most of the time thought they are alot narrower.
> I am looking for a SQL addition to the select statement that would
> allow me to vary the col widith localy in a query.
>
> Thank You
>
> Joe Condle
> Sys Engr
> Medical ARchival Systems, Inc.
> University of Pittsburgh Medical Center
Received on Wed Apr 15 1998 - 11:18:23 CDT