Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trailing spaces
HI,
thanks,
so is my information about varchar2 correct?
or will I have to code round it.
besides, I don't fancy having to update 500-600 columns by hand
steve
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote:
> Update table_name
> set char_column = rtrim(char_column)
>
> and that for all tables.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Steve A <spectre_at_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
Received on Mon Aug 09 1999 - 01:43:53 CDT