Re: Trailing spaces trimmed by default?

On Nov 6, 10:13 am, "Tarby777" <nick_william..._at_mentorg.com> wrote:
> Hi all,
>
> When doing either of these operations in 9i:
>
> create table x as (select * from y);
>
> insert into x(a,b,c) (select a,b,c from y);
>
> ...does Oracle trim trailing spaces from varchar2 columns by default
> and if so, can it be over-ridden? I'm losing some trailing spaces from
> my data during an upgrade and I suspect that one of these operations is
> causing it but I've not been able to reproduce the problem in tests...
>
> TIA
> Tarby

Oracle does NOT trim trailing spaces.
It strikes me in your examples in both cases you are using an inline view where you don't need to. The parentheses are redundant. Maybe they are causing the problem.
Also '9i' is too inaccurate and doesn't tell anything.

-- 
Sybrand Bakker
Senior Oracle DBA