Re: Oracle 7.3.4 : how to write in file, lines larger than 1000 char

From: Alan <alan_at_erols.com>
Date: Thu, 30 Oct 2003 10:59:59 -0500
Message-ID: <bnrcht$14qjmj$1@ID-114862.news.uni-berlin.de>

Why not just do it with SQL? You didn't say what kind of file, but assuming you want a comma-delimited ascii file...

SET FEED OFF
SET PAGES 0
SET ECHO OFF SPOOL c:\my_file.txt

SELECT column_a||','||column_b||','||column_c||','|| etc FROM... SPOOL OFF "Jérôme VUIBERT" <jerome.vuibert_at_fleximage.fr> wrote in message news:3f9f92c7$0$11226$636a55ce_at_news.free.fr...
> Hi.
>
> I really hope than someone could help me to resolve this problem.
>
> I have an old, very old, Oracle 7.3.4 database. I have to get some datas
> from this database and write then in a file.
>
> Unfortunnelly for me, some lines are larger than 1000 characters.
>
> Does someone know how to write in a file some kind of lines ?
>
> Thanks a lot for your help.
>
> Jerome
>
>
Received on Thu Oct 30 2003 - 09:59:59 CST