Re: SQL Plus

From: Neilc <neilc-olops_at_btinternet.com>
Date: Wed, 1 Sep 1999 15:45:34 +0100
Message-ID: <7qje9j$bk8$1@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 - 09:45:34 CDT