Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trailing spaces trimmed by default?

Re: Trailing spaces trimmed by default?

From: sybrandb <sybrandb_at_gmail.com>
Date: 6 Nov 2006 01:53:00 -0800
Message-ID: <1162806780.012098.41320@i42g2000cwa.googlegroups.com>

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
Received on Mon Nov 06 2006 - 03:53:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US