Re: Remove record padding/whitespace after import

Hi

You can use the standardfunctions rtrim and ltrim.

examples:

select rtrim(ltrim(' test ')) from dual ; --> 'test'

update tab_x
set y_col = rtrim(ltrim(y_col));

Regards

Michael Ringbo

Jurgen Fieouren wrote:

> I've recently used an application to export directly to an Oracle 8 table by
> means of an append query and ODBC. Unfortunately, I cannot prevent the
> records from being padded with spaces to their extents. How can I remove
> this waste? Many thanks for any advice . . .
Received on Tue Jan 12 1999 - 05:18:58 CST