Xref: alice comp.databases.oracle.misc:37998
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!colt.net!dispose.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: "Sybrand Bakker" <postmaster@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: trailing spaces
Date: Mon, 9 Aug 1999 06:54:12 +0200
Message-ID: <934174460.7918.0.pluto.d4ee154e@news.demon.nl>
References: <1dw9pqj.ll5kopf3fcjeN@[201.1.1.73]>
Reply-To: "Sybrand Bakker" <postmaster@sybrandb.nospam.demon.nl>
X-Trace: news.demon.nl 934174460 pluto:7918 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Lines: 32

Update table_name
set char_column = rtrim(char_column)

and that for all tables.

Hth,

Sybrand Bakker, Oracle DBA

Steve A <spectre@hkstar.com> wrote in message
news:1dw9pqj.ll5kopf3fcjeN@[201.1.1.73]...
> Hi,
> I've just inported rather alot of data into oracle 8 from foxpro
> I wrote the convesion programs based on the assumption that varchar2
> stripped any trailing spaces.
> I allocated 15 places for a string that is normally 10
>
> However I can only get the following query to work with the trailing
> spaces.
> What I really cannot figure is that I have a lot of  this form of data,
> and some selects work on some tables, minus the trailing spaces, but the
> conversion was the same for all.
>
> "SELECT * FROM reldat where link02_88='CROC0O5SHZ     '"
>
> nothing else will work
>
>
> Is there any utility I can run my databases thru to remove /cure the
> problem, without having to re-import all the data