truncate columns in sql*plus

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 Fri Apr 20 2001 - 10:37:20 CDT