Re: generating flat files with no blank caracters

> I want to generate a flat file so i can use it for partial loads on over
>
> databases, but when i do it with sqlplus, number's columns are completed
>
> with blank caracters and the file can't be use with sqloader. So how i
> should do to get a no blank car file.

Issue your query like this:

SELECT TRIM(column1)||TRIM(column2)||TRIM(column3) FROM table_name;

The TRIM function works on most datatypes including numbers. Received on Wed Oct 24 2001 - 04:05:23 CEST