Re: result of a sql query without Linefeed ?
From: Lee Miller <diamon_at_newsguy.com>
Date: Wed, 10 Jan 2001 16:11:26 -0500
Message-ID: <93ij8r06nk_at_enews1.newsguy.com>
Date: Wed, 10 Jan 2001 16:11:26 -0500
Message-ID: <93ij8r06nk_at_enews1.newsguy.com>
"b powolny" <b.powolny_at_mobilkom.at> wrote in message
news:A3F66.1110$m52.77891_at_nreader2.kpnqwest.net...
> Is there a possibility with SQL plus (or something else for a oracle db)
to
> spool out a result (more than one record) of a query without CR/LF.
PL/SQL can do it but there is a limit to the linesize it can write (somewhere around 400 characters at least in 7.3.X). An easier solution might be to have another program strip off the linefeeds that SQL Plus creates (like perl or sed). Received on Wed Jan 10 2001 - 22:11:26 CET