Re: truncate columns in sql*plus

you can use commands

SQL> column your_column format A30
SQL> select something as your_column from table;

however, be carefull, if selected value will be longer than what you set, you will see only ####

Hope that helps
Jerzy

Henning Steudle wrote:
>
> Hi,
>
> is there a possibility to truncate all columns who are longer then by
> e.g 100 char's or to trim all blancs.
>
> You can see this in sql worksheet. Some colums are truncated where are
> no char's to display e.g columns with varchar2(4000). Other columns
> where the string is longer the hole String is displayed.
>
> The truncate is still set to ON but that doesn´t help.
>
> Any suggestions where appreciated.
>
> Henning
Received on Thu Apr 26 2001 - 13:53:31 CDT