DBMS output limmits

From: Chris Eastwood <c.undieseastwood_at_gu.edu.au>
Date: Fri, 13 Nov 1998 01:40:55 GMT
Message-ID: <72fv6q$oq7$1_at_kraken.itc.gu.edu.au>

HiYa

I was wondering, I want to create an output file that is composed of various line lengths. I think that I have to set the linesize as the length of the maximum line, so as to prevent the output being split across multipule lines.

However this means that the lines that are shorter are then padded with space to fill the extra length.

I think that these spaces are also are cumulative in the limmitation of 1 Meg outout, right?

So if I want to output a file that has occasional long lines, but don't want to waste space on spaces at the end of the lines, and don't want the longer lines broken at the linesize, is there an alternative way?

Maybe some other output package in PL/SQL???

My only other thought is assemble them to a table, and then spool the table from UNIX.

anyone?

Thanks

See Ya
(when bandwidth gets better ;-)

Chris Eastwood

Photographer, Programmer               email    ua.ude.ug.cti_at_doowtsae.c
Motorcyclist and dingbat               WWW   http://chrise.itc.gu.edu.au

please remove undies for reply

---

Ohhh ... you work all day, slave over a hot stove all night  yet you *still* have time for sadomasochism ... how do you do it?

A little man hurts me.

<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Fri Nov 13 1998 - 02:40:55 CET