Re: SQL Plus

Why don't you put these definitions into your glogin.sql (or login.sql, depends which one you use). Then you can use these definitions each time you open sqlplus because sqlplus runs this glogin.sql each time it starts.

Rauno

>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
>>
>>>
>>>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
Received on Wed Sep 01 1999 - 10:55:13 CDT