Re: Flat files and SQLLoader

From: Nuno Guerreiro <nuno-v-guerreiro_at_telecom.pt>
Date: Mon, 07 Sep 1998 14:08:47 GMT
Message-ID: <35f3e881.943363525@news.telecom.pt>

You can also use SELECT * and specify which character should be used as the column separator (a space by default) with the following command:

SET COLSEP ',' Good luck,

Nuno Guerreiro

On Mon, 7 Sep 1998 14:47:33 +0200, "Jean-Philippe Squelbut" <squelbut_at_csi.com> wrote:

>If your table looks like colA, colB, colC,
>don't unload your table by : select * but:
>select colA||','||colB||','||colC ....
>collado_at_my-dejanews.com a écrit dans le message
Received on Mon Sep 07 1998 - 09:08:47 CDT