Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: truncate columns in sql*plus
In addition, you can eliminate trailing blanks by using:
select rtrim(something) as your_column from table;
Jerzy Bin <jerzy.bin_at_chello.at> wrote:
>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 Fri Apr 27 2001 - 13:41:08 CDT