Re: truncate columns in sql*plus

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 20 Apr 2001 23:42:53 -0700
Message-ID: <3AE12BEC.8E9B0655@exesolutions.com>

You can use SUBSTR, LTRIM, and RTRIM to accomplish these goals.

Daniel A. Morgan

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 Sat Apr 21 2001 - 01:42:53 CDT