Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Plus

Re: SQL Plus

From: Jill <jc_va_at_hotmail.com>
Date: Wed, 1 Sep 1999 11:14:05 -0700
Message-ID: <7qjfrj$pus$1@bgtnsc02.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US