Is there anyway to do this globally? We have a table with about 40 or 50
columns, and I just want to select * from it.
Neilc wrote in message <7qje9j$bk8$1_at_pheidippides.axion.bt.co.uk>...
>In sqlplus, before you do the select, use
>
>column customer_no format 99999999999 if customer_no is number
>or
>column customer_no format a11 if customer_no is
>varchar2
>select customer_no from table
>
>
>Cheers
>
>Jill wrote in message <7qjddm$i99$2_at_bgtnsc02.worldnet.att.net>...
>>
>>SQL PLus
>>
>>Does anyone know how to widen the the description in the column heading to
>>display the entire description, and not truncated to the length of the
>>actual data, e.g.
>--snip
>>Thanks for any help
>
>
>
Received on Wed Sep 01 1999 - 13:14:05 CDT
